Content & Component problem | Old Forum | Forum Archive

Hi all,
I have a problem with the jos_content and jos_component in the database.
I set all in JoomlaCloner, the backup start regulary and the clone it's good, but in the last screen view, appears the error that the jos_content and jos_component table, aren't create in the database.
Here the text:

[i]There were some errors while importing the database:
You have an error in your SQL syntax near 'option varchar(50) NOT NULL default '', ordering int(11) NOT NULL default '0', ' at line 1

On Query: CREATE TABLE jos_components ( id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL default '', link varchar(255) NOT NULL default '', menuid int(11) unsigned NOT NULL default '0', parent int(11) unsigned NOT NULL default '0', admin_menu_link varchar(255) NOT NULL default '', admin_menu_alt varchar(255) NOT NULL default '', option varchar(50) NOT NULL default '', ordering int(11) NOT NULL default '0', admin_menu_img varchar(255) NOT NULL default '', iscore tinyint(4) NOT NULL default '0', params text NOT NULL, PRIMARY KEY (id));
Table 'web3.jos_components' doesn't exist

On Query: INSERT INTO jos_components VALUES (1,'Banner','',0,0,'','Gestione banner','com_banners',0,'js/ThemeOffice/component.png',0,'');
Table 'web3.jos_components' doesn't exist

On Query: INSERT INTO jos_components VALUES (2,'Gestione banner','',0,1,'option=com_banners','Banner attivi','com_banners',1,'js/ThemeOffice/edit.png',0,'');
Table 'web3.jos_components' doesn't exist

On Query: INSERT INTO jos_components VALUES (3,'Gestione clienti','',0,1,'option=com_banners&task=listclients','Gestione clienti','com_banners',2,'js/ThemeOffice/categories.png',0,'');
Table 'web3.jos_components' doesn't exist

On Query: INSERT INTO jos_components VALUES (4,'Collegamenti web','option=com_weblinks',0,0,'','Gestione collegamenti web','com_weblinks',0,'js/ThemeOffice/globe2.png',0,'');
Table 'web3.jos_components' doesn't exist

On Query: INSERT INTO jos_components VALUES (5,'Gestione collegamenti web','',0,4,'option=com_weblinks','Vedi collegamenti web esistenti','com_weblinks',1,'js/ThemeOffice/edit.png',0,'');
Table 'web3.jos_components' doesn't exist

On Query: INSERT INTO jos_components VALUES (6,'Categorie collegamenti web','',0,4,'option=categories&section=com_weblinks','Gestione categorie collegamenti web','',2,'js/ThemeOffice/categories.png',0,'');
Table 'web3.jos_components' doesn't exist

On Query: INSERT INTO jos_components VALUES (7,'Contatti','option=com_contact',0,0,'','Modifica dettagli contatti','com_contact',0,'js/ThemeOffice/user.png',1,'');
Table 'web3.jos_components' doesn't exist

On Query: INSERT INTO jos_components VALUES (8,'Gestione Contatti','',0,7,'option=com_contact','Modifica dettagli contatti','com_contact',0,'js/ThemeOffice/edit.png',1,'');
Table 'web3.jos_components' doesn't exist[/i]

...and more

How can I repair that???
Thanks

Post edited by: [email protected], at: 2006/07/13 19:34