Вкарайте в ред тези бази данни.....

G

gogato93

Registered
Моля ви оправете ми базите данни че не мога да се справя!
Ето ги:
phpMyAdmin SQL Dump
version 2.11.1
http://www.phpmyadmin.net

Хост: localhost
Време на генериране: декември 2007 в 21:24
Версия на сървъра: 5.0.45
Версия на PHP: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


БД: `gsm`





Структура на таблица `users`


CREATE TABLE `users` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(250) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`godina` varchar(250) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`kartinka` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`model` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`mreja` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`bateria` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`resol` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`colors` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`displey` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`golemina` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`teglo` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`pamet` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`slot` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`kamera` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`svetkavica` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`mptri` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`radio` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`gps` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`videoaudio` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`paneli` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`fax` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`sms` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`wap` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`modem` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`irda` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`gprs` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`wifi` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`HSCSD` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`edge` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`xhtml` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`bluetooth` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`usb` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`talk` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`email` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
`java` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=23 ;

--
-- Дъмп (схема) на данните в таблицата `users`
--

INSERT INTO `users` (`id`, `name`, `godina`, `kartinka`, `model`, `mreja`, `bateria`, `resol`, `colors`, `displey`, `golemina`, `teglo`, `pamet`, `slot`, `kamera`, `svetkavica`, `mptri`, `radio`, `gps`, `videoaudio`, `paneli`, `fax`, `sms`, `wap`, `modem`, `irda`, `gprs`, `wifi`, `HSCSD`, `edge`, `xhtml`, `bluetooth`, `usb`, `talk`, `email`, `java`) VALUES
(19, 'Nokia N73', '2006', 'http://mobilebulgaria.com/uploads/mobiles/2006/01/pic_3_1080.jpg', '2', 'UMTS / GSM 850/900/1800/1900', 'Li-Ion 700 mAh', '240 x 320 пиксела', '260k', 'TFT', '49 x 110 x 19 mm', '90 гр', '42 mb', 'Mini SD', '2 MP', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', '2.0', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', '', 'Да', 'Да', 'Да', 'Да'),
Увеличете...
-- phpMyAdmin SQL Dump
-- version 2.11.1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Време на генериране: декември 2007 в 20:11
-- Версия на сървъра: 5.0.45
-- Версия на PHP: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- БД: `music`
--

-- --------------------------------------------------------

--
-- Структура на таблица `songs`
--

CREATE TABLE `songs` (
`id` int(4) NOT NULL auto_increment,
`author` varchar(255) NOT NULL,
`artist` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`path` varchar(255) NOT NULL,
`year` varchar(255) NOT NULL,
`album` varchar(255) NOT NULL,
`size` varchar(255) NOT NULL,
`cat` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`broken` varchar(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Дъмп (схема) на данните в таблицата `songs`
--

INSERT INTO `songs` (`id`, `author`, `artist`, `title`, `path`, `year`, `album`, `size`, `cat`, `date`, `broken`) VALUES

;

-- --------------------------------------------------------

--
-- Структура на таблица `songs_cat`
--

CREATE TABLE `songs_cat` (
`id` int(4) NOT NULL auto_increment,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

--
-- Дъмп (схема) на данните в таблицата `songs_cat`
--

INSERT INTO `songs_cat` (`id`, `value`) VALUES
(1, 'Поп фолк'),
(2, 'Club'),
(3, 'Dance'),
(4, 'Electronic'),
(5, 'Gothic'),
(6, 'Hip-Hop'),
(7, 'JazZ'),
(8, 'Latin'),
(9, 'Pop'),
(10, 'Psychedelic'),
(11, 'R&B'),
(12, 'Reggae'),
(13, 'Rock'),
(14, 'Techno'),
(15, 'Народна'),
(16, 'Класическа'),
(17, 'Филмова'),
(18, 'Drum''n''Bass'),
(19, 'Retro'),
(20, 'Детска'),
(21, 'House'),
(22, 'Jungle'),
(23, 'Metal'),
(24, 'Punk'),
(25, 'Rap'),
(26, 'Reggaeton'),
(27, 'Trance'),
(28, 'Друга');
Увеличете...
ПС:Благодаря ви предварително!Който ми ги оправи ще получи точка :)
 
Код: 
CREATE TABLE `users` ( 
`id` int(10) NOT NULL auto_increment, 
`name` varchar(250) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`godina` varchar(250) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`kartinka` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`model` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`mreja` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`bateria` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`resol` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`colors` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`displey` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`golemina` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`teglo` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`pamet` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`slot` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`kamera` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`svetkavica` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`mptri` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`radio` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`gps` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`videoaudio` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`paneli` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`fax` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`sms` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`wap` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`modem` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`irda` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`gprs` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`wifi` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`HSCSD` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`edge` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`xhtml` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`bluetooth` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`usb` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`talk` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`email` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
`java` varchar(255) character set cp1251 collate cp1251_bulgarian_ci NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=23 ; 

-- 
-- Дъмп (схема) на данните в таблицата `users` 
-- 

INSERT INTO `users` (`id`, `name`, `godina`, `kartinka`, `model`, `mreja`, `bateria`, `resol`, `colors`, `displey`, `golemina`, `teglo`, `pamet`, `slot`, `kamera`, `svetkavica`, `mptri`, `radio`, `gps`, `videoaudio`, `paneli`, `fax`, `sms`, `wap`, `modem`, `irda`, `gprs`, `wifi`, `HSCSD`, `edge`, `xhtml`, `bluetooth`, `usb`, `talk`, `email`, `java`) VALUES 
(19, 'Nokia N73', '2006', 'http://mobilebulgaria.com/uploads/mobiles/2006/01/pic_3_1080.jpg', '2', 'UMTS / GSM 850/900/1800/1900', 'Li-Ion 700 mAh', '240 x 320 пиксела', '260k', 'TFT', '49 x 110 x 19 mm', '90 гр', '42 mb', 'Mini SD', '2 MP', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', '2.0', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', 'Да', '', 'Да', 'Да', 'Да', 'Да'),

Код: 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 


CREATE TABLE `songs` ( 
`id` int(4) NOT NULL auto_increment, 
`author` varchar(255) NOT NULL, 
`artist` varchar(255) NOT NULL, 
`title` varchar(255) NOT NULL, 
`path` varchar(255) NOT NULL, 
`year` varchar(255) NOT NULL, 
`album` varchar(255) NOT NULL, 
`size` varchar(255) NOT NULL, 
`cat` varchar(255) NOT NULL, 
`date` varchar(255) NOT NULL, 
`broken` varchar(255) NOT NULL default '0', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ; 


INSERT INTO `songs` (`id`, `author`, `artist`, `title`, `path`, `year`, `album`, `size`, `cat`, `date`, `broken`) VALUES 

; 

CREATE TABLE `songs_cat` ( 
`id` int(4) NOT NULL auto_increment, 
`value` varchar(255) NOT NULL, 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=32 ; 



INSERT INTO `songs_cat` (`id`, `value`) VALUES 
(1, 'Поп фолк'), 
(2, 'Club'), 
(3, 'Dance'), 
(4, 'Electronic'), 
(5, 'Gothic'), 
(6, 'Hip-Hop'), 
(7, 'JazZ'), 
(8, 'Latin'), 
(9, 'Pop'), 
(10, 'Psychedelic'), 
(11, 'R&B'), 
(12, 'Reggae'), 
(13, 'Rock'), 
(14, 'Techno'), 
(15, 'Народна'), 
(16, 'Класическа'), 
(17, 'Филмова'), 
(18, 'Drum''n''Bass'), 
(19, 'Retro'), 
(20, 'Детска'), 
(21, 'House'), 
(22, 'Jungle'), 
(23, 'Metal'), 
(24, 'Punk'), 
(25, 'Rap'), 
(26, 'Reggaeton'), 
(27, 'Trance'), 
(28, 'Друга');
 
На първия виж какво дава :(
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 383
STR: `
SQL:

--
-- ���� (�����) �� ������� � ��������� `users`
--

INSERT INTO `users` (`id`, `name`, `godina`, `kartinka`, `model`, `mreja`, `bateria`, `resol`, `colors`, `displey`, `golemina`, `teglo`, `pamet`, `slot`, `kamera`, `svetkavica`, `mptri`, `radio`, `gps`, `videoaudio`, `paneli`, `fax`, `sms`, `wap`, `modem`, `irda`, `gprs`, `wifi`, `HSCSD`, `edge`, `xhtml`, `bluetooth`, `usb`, `talk`, `email`, `java`) VALUES
(19, 'Nokia N73', '2006', 'http://mobilebulgaria.com/uploads/mobiles/2006/01/pic_3_1080.jpg', '2', 'UMTS / GSM 850/900/1800/1900', 'Li-Ion 700 mAh', '240 x 320 �������', '260k', 'TFT', '49 x 110 x 19 mm', '90 ��', '42 mb', 'Mini SD', '2 MP', '��', '��', '��', '��', '��', '��', '��', '��', '2.0', '��', '��', '��', '��', '��', '��', '��', '', '��', '��', '��', '��'),


SQL query:

-- -- ���� (�����) �� ������� � ��������� `users` -- INSERT INTO `users` (`id`, `name`, `godina`, `kartinka`, `model`, `mreja`, `bateria`, `resol`, `colors`, `displey`, `golemina`, `teglo`, `pamet`, `slot`, `kamera`, `svetkavica`, `mptri`, `radio`, `gps`, `videoaudio`, `paneli`, `fax`, `sms`, `wap`, `modem`, `irda`, `gprs`, `wifi`, `HSCSD`, `edge`, `xhtml`, `bluetooth`, `usb`, `talk`, `email`, `java`) VALUES (19, 'Nokia N73', '2006', 'http://mobilebulgaria.com/uploads/mobiles/2006/01/pic_3_1080.jpg', '2', 'UMTS / GSM 850/900/1800/1900', 'Li-Ion 700 mAh', '240 x 320 �������', '260k', 'TFT', '49 x 110 x 19 mm', '90 ��', '42 mb', 'Mini SD', '2 MP', '��', '��', '��', '��', '��', '��', '��', '��', '2.0', '��', '��', '��', '��', '��', '��', '��', '', '��', '��', '��', '��'),

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Увеличете...
 
На второто виж
Error

SQL query:

INSERT INTO `songs` ( `id` , `author` , `artist` , `title` , `path` , `year` , `album` , `size` , `cat` , `date` , `broken` )
VALUES ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Увеличете...
 
Моля ви кажете ми как ще стане.Сайта е пуснат в хоста а аз не мга да го оправя.Моля ви ще ви дам точка.Моля ви...... :cry:
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе