Fixing several SQL queries on a OSCMAX Multi Stores setup (MySQL 5 server)
$30-100 USD
Concluído
Publicado há aproximadamente 16 anos
$30-100 USD
Pago na entrega
Finishing a Multi-Stores installation on a OSCMAX (OSCommerce) working store. Mainly SQL queries, everything else is about done.
A few SQL queries need to be fixed to work on a MySQL 5 server (1054 error, () needed on joins?) and a few more files need their SQL query changed to include the Multi-Store changes (so products available on store A but not active on store B will not be viewed on store B).
## Deliverables
Running a live store at [login to view URL] with OSCMAX , and now I have installed on it Multi-Stores in order to have several stores running on the same OSC database.
The test store has been set up on [login to view URL] and seems to be working ok with the following glitches.
Note that store template is not /templates/fallback , but I prefer to have the queries on the default template fixed instead that in our template, so I can later just apply the changes on our template.
-----
/[login to view URL] shows all products, and not just those active on the given store. Query that needs to be modified on /templates/fallback/content/[login to view URL]
($products_query on line 33?)
-----
1054 error when trying to see categories tree. 8 queries that need to be adapted (to MySQL5 database server?) on index.php.
1054 - Unknown column 's.specials_id' in 'on clause'
You can see the queries on the following URL, 2 last posts on the page:
[login to view URL]
-----
Error when doing a product search on store. Query that need to be fixed/adapted (to MySQL5 database server?) on /templates/fallback/content/[login to view URL]
1066 - Not unique table/alias: 'c'
-----
/[login to view URL] shows all products, and not just those active on the current store. Query that needs to be modified on
/templates/fallback/content/[login to view URL]
($products_query_raw on line 311?)
-----
/includes/modules/[login to view URL] shows all products, and not just those active on the given store. Query that needs to be modified.
($specials_query_raw on lines 44 and 48? two queries since I have SPPC installed, first one for retail group`, second one for others)
-----
/googlesitemap/[login to view URL] creates three sitemaps for google:
/[login to view URL]
/[login to view URL]
/[login to view URL]
Two SQL queries on /googlesitemap/[login to view URL] need to be modified so sitemaps will only include categories and products available on the given store (functions GenerateProductSitemap and GenerateCategorySitemap)
-----
/includes/modules/[login to view URL] cross sell products, when seeing a product on one store, the related products that are not active on that store can be seen too. Query that needs to be modified.
($xsell_query on line 33?)
-----
There might be a few more places where a query needs to be fixed, but they should be about the same as previous queries (just make it so it filters the query given the current store number), I have not yet been able to test throughly mainly due to the failing SQL queries on [login to view URL]