INSERARE TABELA IN BAZA DE DATE

[Marius05]

Va salut!

 

Gaseste cineva problema la aceasta comanda in baza de de date pentru PS1.4.8 ?

 

$query = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'customerage` (

`id_customer` int(11) NOT NULL,

`name` text,

`name_again` text,

`is_show` int(11) NOT NULL default \'0\',

KEY `id_customer` (`id_customer`)

) ENGINE='.(defined('_MYSQL_ENGINE_')?_MYSQL_ENGINE_:"MyISAM").' DEFAULT CHARSET=utf8';

 

Ma omoara de cateva ore si nu-i dau de cap

 

Va multumesc !

[Marius05]

Daca cineva vrea sa imi spuna unde e problema nu ma supar !!!

Am incercat o gramada de variante si nu vrea ....

Edited June 10, 2012 by Marius05 (see edit history)

[lightsb]

incearca pe local host ..

 

 

CREATE TABLE IF NOT EXISTS `ps_customerage` (

`id_customer` int(11) NOT NULL,

`name` text,

`name_again` text,

`is_show` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id_customer`)

[Marius05]

Eroare: #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 6

[valentin.g]

NOT NULL default 0

[lightsb]

CREATE TABLE IF NOT EXISTS `ps_customerage` (

`id_customer` int(11) NOT NULL,

`name` text,

`name_again` text,

`is_show` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id_customer`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

 

 

am incercat pe localhost si merge ...

[Marius05]

Intradevar, merge. Multumesc lightsb.