Problème d'upload de database sur phpmyadmin
Bonjour, j'ai un problème et je crois qu'il est facilement réglable. Avant d'essayer quoi que se soit je voudrais avoir l'avis d'une personne qui en connait plus que moi dans ce domaine :
Erreur
Il semble qu'il y ait une erreur dans votre requête SQL. Le message ci-bas peut vous aider à en trouver la cause.
ERROR: Identificateur invalide @ 167
STR: 5.0.
SQL: -- phpMyAdmin SQL Dump
-- version 2.8.1
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generaci�n: 18-01-2008 a las 07:01:20
-- Versi�n del servidor: 5.0.21
-- Versi�n de PHP: 5.1.4
--
-- Base de datos: `22`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `tb_ads`
--
CREATE TABLE `tb_ads` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(150) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
`tipo` varchar(150) collate latin1_general_ci NOT NULL,
`visitime` varchar(150) collate latin1_general_ci NOT NULL,
`ident` varchar(150) collate latin1_general_ci NOT NULL,
`fechainicia` varchar(150) collate latin1_general_ci NOT NULL,
`paypalname` varchar(150) collate latin1_general_ci NOT NULL,
`paypalemail` varchar(150) collate latin1_general_ci NOT NULL,
`plan` varchar(150) collate latin1_general_ci NOT NULL,
`bold` varchar(150) collate latin1_general_ci NOT NULL,
`highlight` varchar(150) collate latin1_general_ci NOT NULL,
`url` varchar(150) collate latin1_general_ci NOT NULL,
`description` varchar(150) collate latin1_general_ci NOT NULL,
`category` varchar(150) collate latin1_general_ci NOT NULL,
`members` varchar(150) collate latin1_general_ci NOT NULL default '0',
`outside` varchar(150) collate latin1_general_ci NOT NULL default '0',
`total` varchar(150) collate latin1_general_ci NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;
requête SQL:
-- phpMyAdmin SQL Dump -- version 2.8.1 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost -- Tiempo de generaci�n: 18-01-2008 a las 07:01:20 -- Versi�n del servidor: 5.0.21 -- Versi�n de PHP: 5.1.4 -- -- Base de datos: `22` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `tb_ads` -- CREATE TABLE `tb_ads` ( `id` int(11) NOT NULL auto_increment, `user` varchar(150) collate latin1_general_ci NOT NULL, `ip` varchar(15) collate latin1_general_ci NOT NULL, `tipo` varchar(150) collate latin1_general_ci NOT NULL, `visitime` varchar(150) collate latin1_general_ci NOT NULL, `ident` varchar(150) collate latin1_general_ci NOT NULL, `fechainicia` varchar(150) collate latin1_general_ci NOT NULL, `paypalname` varchar(150) collate latin1_general_ci NOT NULL, `paypalemail` varchar(150) collate latin1_general_ci NOT NULL, `plan` varchar(150) collate latin1_general_ci NOT NULL, `bold` varchar(150) collate latin1_general_ci NOT NULL, `highlight` varchar(150) collate latin1_general_ci NOT NULL, `url` varchar(150) collate latin1_general_ci NOT NULL, `description` varchar(150) collate latin1_general_ci NOT NULL, `category` varchar(150) collate latin1_general_ci NOT NULL, `members` varchar(150) collate latin1_general_ci NOT NULL default '0', `outside` varchar(150) collate latin1_general_ci NOT NULL default '0', `total` varchar(150) collate latin1_general_ci NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;
MySQL a répondu:Documentation
#1046 - No database selected
--------------------------------------
Que dois-je faire? Dois-je remplacer NOT NULL par quelquechose?
Si oui, pourriez-vous m'expliquer :
id
ip
tipo
ident
fechainicia
Erreur
Il semble qu'il y ait une erreur dans votre requête SQL. Le message ci-bas peut vous aider à en trouver la cause.
ERROR: Identificateur invalide @ 167
STR: 5.0.
SQL: -- phpMyAdmin SQL Dump
-- version 2.8.1
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generaci�n: 18-01-2008 a las 07:01:20
-- Versi�n del servidor: 5.0.21
-- Versi�n de PHP: 5.1.4
--
-- Base de datos: `22`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `tb_ads`
--
CREATE TABLE `tb_ads` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(150) collate latin1_general_ci NOT NULL,
`ip` varchar(15) collate latin1_general_ci NOT NULL,
`tipo` varchar(150) collate latin1_general_ci NOT NULL,
`visitime` varchar(150) collate latin1_general_ci NOT NULL,
`ident` varchar(150) collate latin1_general_ci NOT NULL,
`fechainicia` varchar(150) collate latin1_general_ci NOT NULL,
`paypalname` varchar(150) collate latin1_general_ci NOT NULL,
`paypalemail` varchar(150) collate latin1_general_ci NOT NULL,
`plan` varchar(150) collate latin1_general_ci NOT NULL,
`bold` varchar(150) collate latin1_general_ci NOT NULL,
`highlight` varchar(150) collate latin1_general_ci NOT NULL,
`url` varchar(150) collate latin1_general_ci NOT NULL,
`description` varchar(150) collate latin1_general_ci NOT NULL,
`category` varchar(150) collate latin1_general_ci NOT NULL,
`members` varchar(150) collate latin1_general_ci NOT NULL default '0',
`outside` varchar(150) collate latin1_general_ci NOT NULL default '0',
`total` varchar(150) collate latin1_general_ci NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;
requête SQL:
-- phpMyAdmin SQL Dump -- version 2.8.1 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost -- Tiempo de generaci�n: 18-01-2008 a las 07:01:20 -- Versi�n del servidor: 5.0.21 -- Versi�n de PHP: 5.1.4 -- -- Base de datos: `22` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `tb_ads` -- CREATE TABLE `tb_ads` ( `id` int(11) NOT NULL auto_increment, `user` varchar(150) collate latin1_general_ci NOT NULL, `ip` varchar(15) collate latin1_general_ci NOT NULL, `tipo` varchar(150) collate latin1_general_ci NOT NULL, `visitime` varchar(150) collate latin1_general_ci NOT NULL, `ident` varchar(150) collate latin1_general_ci NOT NULL, `fechainicia` varchar(150) collate latin1_general_ci NOT NULL, `paypalname` varchar(150) collate latin1_general_ci NOT NULL, `paypalemail` varchar(150) collate latin1_general_ci NOT NULL, `plan` varchar(150) collate latin1_general_ci NOT NULL, `bold` varchar(150) collate latin1_general_ci NOT NULL, `highlight` varchar(150) collate latin1_general_ci NOT NULL, `url` varchar(150) collate latin1_general_ci NOT NULL, `description` varchar(150) collate latin1_general_ci NOT NULL, `category` varchar(150) collate latin1_general_ci NOT NULL, `members` varchar(150) collate latin1_general_ci NOT NULL default '0', `outside` varchar(150) collate latin1_general_ci NOT NULL default '0', `total` varchar(150) collate latin1_general_ci NOT NULL default '0', KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=29 ;
MySQL a répondu:Documentation
#1046 - No database selected
--------------------------------------
Que dois-je faire? Dois-je remplacer NOT NULL par quelquechose?
Si oui, pourriez-vous m'expliquer :
id
ip
tipo
ident
fechainicia
Configuration: Windows XP Firefox 3.0.3
4 réponses
-
tu as l'erreur
MySQL a répondu:Documentation
#1046 - No database selected
essaye de choisir une base de données avant de creer ce tableau -
Comme l'a dit imed, il faut selectionner une base de données puis executer ce script sql dedans.
Bon travail -
Lol je vais faire ça...
Désolé du dérangement! -
Pas de probleme