Codice:
Errore
query SQL:
--
-- Dati di salvataggio di `melodie`
--
INSERT INTO `melodie` ( `id` , `titlu` , `categorie` , `hits` , `linkascultare` , `teaserlink` , `videolink` , `data_ad` , `link` , `link2` , `descriere` , `linkpoza` , `uploadat` , `tags` , `ip` )
VALUES -- --------------------------------------------------------
--
-- Struttura tabella per la tabella `tags`
--
CREATE TABLE IF NOT EXISTS `tags` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`cautare` text,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =10277;
Messaggio di MySQL: Documentazione
#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 'CREATE TABLE IF NOT EXISTS `tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`c' at line 5
Il file completo è questo:
Codice:
-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- Gazda: localhost
-- Timp de generare: 04 Iul 2012 la 07:42
-- Versiune server: 5.1.58
-- Versiune PHP: 5.2.17
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Baza de date: `uuuu_hot_data_base`
--
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `melodie`
--
CREATE TABLE IF NOT EXISTS `melodie` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`titlu` varchar(255) DEFAULT NULL,
`categorie` varchar(255) DEFAULT NULL,
`hits` int(6) DEFAULT NULL,
`linkascultare` varchar(255) DEFAULT NULL,
`teaserlink` varchar(255) DEFAULT NULL,
`videolink` varchar(255) DEFAULT NULL,
`data_ad` datetime DEFAULT NULL,
`link` varchar(255) DEFAULT NULL,
`link2` varchar(255) DEFAULT NULL,
`descriere` text,
`linkpoza` varchar(255) DEFAULT NULL,
`uploadat` text,
`tags` text,
`ip` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9543 ;
--
-- Salvarea datelor din tabel `melodie`
--
INSERT INTO `melodie` (`id`, `titlu`, `categorie`, `hits`, `linkascultare`, `teaserlink`, `videolink`, `data_ad`, `link`, `link2`, `descriere`, `linkpoza`, `uploadat`, `tags`, `ip`) VALUES
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `tags`
--
CREATE TABLE IF NOT EXISTS `tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cautare` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10277 ;
--
-- Salvarea datelor din tabel `tags`
--
INSERT INTO `tags` (`id`, `cautare`) VALUES
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`password` varchar(32) NOT NULL,
`userid` varchar(32) NOT NULL,
`userlevel` tinyint(1) unsigned NOT NULL,
`email` varchar(50) NOT NULL,
`timestamp` int(11) unsigned NOT NULL,
`melodii` varchar(32) NOT NULL,
`ip` varchar(32) NOT NULL,
`data` date NOT NULL,
`descarcari` varchar(32) NOT NULL DEFAULT '0',
`descarcate` varchar(32) NOT NULL DEFAULT '0,0,0,0,0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=329 ;
--
-- Salvarea datelor din tabel `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `userid`, `userlevel`, `email`, `timestamp`, `melodii`, `ip`, `data`, `descarcari`, `descarcate`) VALUES
(326, 'DjChinezu', '0868ca830d79cf5f2280c8cc04c1480f', '5c65dba2efe99d2883c8091827ef6232', 9, 'mp3aleseinfo@yahoo.com', 1262094740, '', '', '0000-00-00', '0', '0,0,0,0,0'),
(201, 'djbiker', '39a298dcf7b125331d08cb740405794f', '2adb578deaaac1d6c835149baded291a', 2, 'djbiker_cipriku@yahoo.com', 1262036545, '', '89.41.155.200', '2009-12-28', '0', '0,0,0,0,0'),
(327, 'mihaino1', '00a1f187721c63501356bf791e69382c', 'af913c382293bf86a0272b67f9d3240f', 2, 'yo_mihaitza_94@yahoo.com', 1262096322, '', '92.80.217.87', '2009-12-29', '0', '0,0,0,0,0'),
(328, 'woody', '25f9e794323b453885f5181f1b624d0b', '63f9e85cb4a84d1a2c11045743c18860', 9, 'gyurka_mircea@yahoo.com', 1262101074, '', '', '0000-00-00', '125', '15');
Lo script me lo ha passato un amico, la lingua penso sia romena, dato che è uno script romeno.Google translate questo mi ha detto.