Problem with the installation "ot_valupat_demo_package"

Hallo,

I have a problem with the installation "ot_valupat_demo_package"
Joomla installation at Step 4: Database - error message "Some errors occurred
while populating the database: Table 'athen2.spwt2_usergroups' doesn't
exist SQL=INSERT INTO `spwt2_usergroups` (`id`, `parent_id`, `lft`,
`rgt`, `title`) VALUES (1, 0, 1, 20, 'Public'), (2, 1, 6, 17,
'Registered'), (3, 2, 7, 14, 'Author'), (4, 3, 8, 11, 'Editor'), (5,
4, 9, 10, 'Publisher'), (6, 1, 2, 5, 'Manager'), (7, 6, 3, 4,
'Administrator'), (8, 1, 18, 19, 'Super Users'), (10, 3, 12, 13, 'Shop
Suppliers (Example)'), (12, 2, 15, 16, 'Customer Group (Example)')"


please help me!!!!

Hi,
Please see here
( www.omegatheme.com/ot-fashion/can-t-inst...start_demo.html#1780 )
This only happens on some MySql version.

Thanks

Good Day, I have the same kind of problem but with another table. My SQL version is 5.5.25

Some errors occurred while populating the database: 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 SQL=INSERT INTO `ukn2i_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES (23, 'index.php?option=com_k2&view=item&id=23', 'index.php?option=com_k2&view=item&id=23:content-demo-115&Itemid=502', 'Content Demo 1.1.5', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-06-19 09:46:03', '75d37d8675fbdec9a2323de5351571a3', 1, 1, 1, '*', '2012-06-11 07:03:15', '0000-00-00 00:00:00', '2012-06-11 07:03:15', '0000-00-00 00:00:00', 0, 0, 1, 0x4f3a31393a2246696e646572496 etc. etc. etc.

I checked the Joomla, sample data, sample blog and sample brochure SQL files, but cannot find this table in them. Where can I find this table and what is the correct syntax?
Thank you
Belinda

bfrylinck wrote: Good Day, I have the same kind of problem but with another table. My SQL version is 5.5.25
...
I checked the Joomla, sample data, sample blog and sample brochure SQL files, but cannot find this table in them. Where can I find this table and what is the correct syntax?
Thank you
Belinda

Hi,
Please search in joomla.sql, sample_data.sql and find "INSERT INTO `#__finder_links`" and you can try remove the insert into this table

Thanks

Good Day

Thank you for your help so far. I've removed the insert statements as per your advise. However, I am getting more SQL errors now including that the _schemes table cannot be found (the CREATE statement is in the sql file - I checked) and that there is an error in the insert statement for the _content table. I need to be able to install the demo package URGENTLY - can you please send me SQL files without syntax errors.

thank you

Hello Friends,

Please download demo installation zip file again and remember drop all tables in your database before install demo site again. It will work fine!

Thanks