Printable View
Table Prefixes...
I was wondering about the table prefix I have, it's not the defaults.
Will this cause problems if I simply change them in the sql? Or do I have to also find them in the pages and adjust them there somewhere as well.
If so, could you please advise which files will need to be modified.
Finally, I'm running 1.3.7, not 1.3.8... Please tell me that won't be an issue... ;)
Ray
If you set up the prefixes as part of your initial install of Zen Cart, then you should be able to just run the sql statement from admin -> tools -> install sql patches without problems.Quote:
Originally Posted by RayDube
The same would also apply for the the pages which query the database.
I would appreciate it if people did not use my link exchange as a test to see whether they want to install it themsleves. This happened last night and its not welcome. Cheers.
Quote:
Originally Posted by Crooked_Halo
You could always set links manager so that only registered customers could submit links.
admin -> configuration -> links manager
On the Admin->Extras->Links Categories page the Sort Order works properly and the categories are displayed in sort order. However, when viewing the categories list from the catalog they are listed in alphabetical order.
I have looked in the configurations but have not been able to locate any options for this display.
Open includes/templates/YOUR_TEMPLATE/templates/tpl_links_default.phpQuote:
Originally Posted by Asgoroth
find the following line of code (around line 19):
and replace it with this line:PHP Code:$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lcd.link_categories_name");
PHP Code:$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lcd.link_categories_sort_order");
I tried this fix on 2 sitesQuote:
Originally Posted by clydejones
it fixes the sort order for the online catalog, but no in the admin area:(
both site also get this error when you click on "view all link" :no:
1054 Unknown column 'lcd.link_categories_sort_order' in 'order clause'
in:
[select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from link_categories lc, link_categories_description lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '1' order by lcd.link_categories_sort_order]
revert back to the original line of code and I'll check out the error message.Quote:
Originally Posted by fvb
This line of code will eliminate the error:Quote:
Originally Posted by clydejones
PHP Code:$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lc.link_categories_sort_order, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lc.link_categories_sort_order");
thanks, I will try it tonight and let you knowQuote:
Originally Posted by clydejones