OLD-6608: Isntall sample data - non-functional

[cpaschen]

Description

The 'install sample data' tool isn't installing anything.

(Tested with a couple products already in the catalog)

History

#5 Updated by Chris DioscouriChris Paschen. 6 months ago

BTW ... here's the error notice (on step 7) from the 'clothing store' installation results:

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 'INTOjos_tienda_productcategoryxref (category_id, product_id) VALUES ('1' at line 1 SQL=INSERT IGNOR INTOjos_tienda_productcategoryxref (category_id, product_id) VALUES ('1', '1'), ('6', '2'), ('7', '3'), ('2', '4'), ('3', '5');

#4 Updated by Chris DioscouriChris Paschen. 6 months ago

Assignee set to Chris DioscouriChris Paschen.

FYI the above was when testing using the 'electronics' sample data.

When installing with the 'clothing store' we get a lot of "COM_TIENDA_COM_TIENDA_TABLE" entries in the 'DATA' column for the installation results (language string problem).

#3 Updated by Chris DioscouriChris Paschen. 6 months ago

Affected Version changed from 0.8.3 pre-E to 0.8.3 pre-E / 0.9.0

Even with the error, there are some products installed.

#2 Updated by Chris DioscouriChris Paschen. 6 months ago

Getting the following error (on a clean Joomla/Tienda install):

Step 7
Table 7
Affected Rows -1

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 'INTOjos_productcategoryxref (category_id, product_id) VALUES ('2' at line 1 SQL=INSERT IGNOR INTOjos_tienda_productcategoryxref (category_id, product_id) VALUES ('2', '1'), ('5', '2'), ('8', '3');

(Could it just be the fact that 'IGNORE' is spelled 'IGNOR'????)

#1 Updated by Chris DioscouriChris Paschen. 8 months ago

Target version changed from Version 0.9.0 - Major Core Fixes to Version 0.9.4 - Plugin Testing and Finalization

[ChrisFrench]

Chris P,

So to make sure i am not missing anything, I was under the impression that sample data would only install on a blank tienda site, but that this was on purpose.
If so we can probably close this correct?

[ChrisFrench]

Hey Rafael, I had a question. The sample data is a little bit lame right now, the way 2.5 handles users we can't assign the users ids to the products maybe we can come up with some fancy queries.

However what I am thinking is we maybe should just drop the whole sample data system and just move to the XML importing system and use that for the same data? it seems to me the XML would be the best way to support all the versions also sample data doesn't support images

[rdiaztushman]

regarding the users=>products relationship -- what do you mean? i thought we only depended on the user.id, and that still exists.

regarding an xml import vs sample SQL -- i'm fine with that.

[ChrisFrench]

well in 1.5 we always know that the user_id of the default admin. in 2.5 the id's are random so when installing the sample data we are going to do it make it have several sub select queries to get the user id.

I was going to do this until i thought we should just remove the sample data system all together and focus on XML importer

[rdiaztushman]

re user_id 62 -- good point. Is there a way we can just set a SQL variable at the beginning of the import script and reuse it throughout? something like:

SET @admin_id = SELECT MIN(id) FROM #__users WHERE ACL = {Super Administrator}

[ChrisFrench]

Yea, Since i think both of these are low on the totem poll i will come back to them when we got the other systems finished