Selesai

Fixing several SQL queries on a OSCMAX Multi Stores setup (MySQL 5 server)

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 [url removed, login to view] 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 [url removed, login to view] 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.

-----

/[url removed, login to view] shows all products, and not just those active on the given store. Query that needs to be modified on /templates/fallback/content/[url removed, login to view]

($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:

[url removed, login to view]

-----

Error when doing a product search on store. Query that need to be fixed/adapted (to MySQL5 database server?) on /templates/fallback/content/[url removed, login to view]

1066 - Not unique table/alias: 'c'

-----

/[url removed, login to view] shows all products, and not just those active on the current store. Query that needs to be modified on

/templates/fallback/content/[url removed, login to view]

($products_query_raw on line 311?)

-----

/includes/modules/[url removed, login to view] 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/[url removed, login to view] creates three sitemaps for google:

/[url removed, login to view]

/[url removed, login to view]

/[url removed, login to view]

Two SQL queries on /googlesitemap/[url removed, login to view] need to be modified so sitemaps will only include categories and products available on the given store (functions GenerateProductSitemap and GenerateCategorySitemap)

-----

/includes/modules/[url removed, login to view] 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 [url removed, login to view]

Keahlian: Teknik, MySQL, PHP, Perancangan Perangkat Lunak, Pengujian Perangkat Lunak, Hosting Web, Manajemen Situs Web, Pengujian Situs Web

Lihat lebih lanjut: where two lines cross, tree query, tree in order, tree index, template html 5 search, search a tree, projects on line, on line projects, mysql database server, index tree, fixing com, everything $5 store, engineering projects needed, cross with two lines, allprods php, $5 everything store, google places categories, sell a url, html on line, test sql server, sql queries, sql projects, queries, php error fixing, oscmax

Tentang Pemberi kerja:
( 12 ulasan ) Barcelona, Spain

ID Proyek: #3856322

Diberikan kepada:

streamlinetechvw

See private message.

$51 USD dalam 7 hari
(7 Ulasan)
3.2