cart not working error 500 on debug

  • Posts: 102
  • Thank you received: 0
13 years 2 weeks ago #29504

hi nicolas,
i added some custom fields and my cart stopped processing. click place order and nothing happens. so i turned on debug and then when trying to access the home page i get the following error message i cant even get to any store pages:

JDatabaseMySQL::query: 1054 - Unknown column 'ordering' in 'order clause' SQL=SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC

If difficulties persist, please contact the System Administrator of this site and report the error below.

Call stack
# Function Location
1 JSite->dispatch() /home/diablo/public_html/index.php:43
2 JSite->getParams() /home/diablo/public_html/includes/application.php:163
3 JLanguageHelper::getLanguages() /home/diablo/public_html/includes/application.php:359
4 JDatabase->loadObjectList() /home/diablo/public_html/libraries/joomla/language/helper.php:143
5 JDatabaseMySQLi->query() /home/diablo/public_html/libraries/joomla/database/database.php:975
6 JError::raiseError() /home/diablo/public_html/libraries/joomla/database/database/mysqli.php:535
7 JError::raise() /home/diablo/public_html/libraries/joomla/error/error.php:250

any thoughts?
thanks Liz

this is with joomla 1.7.1 and hikashop 1.5.4

moreinfo: so i deleted the new fields (3 Order fields and 1 Product Field) and now the store works.

Last edit: 13 years 2 weeks ago by MinnieMouse. Reason: more info

Please Log in or Create an account to join the conversation.

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
13 years 2 weeks ago #29507

Hi,

That problem is not related to HikaShop.
It's a problem coming from the fact that you updated from 1.6 to 1.7:
groups.google.com/group/joomla-dev-gener...ead/9336f421b6d33b7f
You should try the manual update procedure explained there (and more specifically the database update):
docs.joomla.org/Upgrading_1.6.5_to_1.7#M...pload.2FInstallation

Please Log in or Create an account to join the conversation.

  • Posts: 102
  • Thank you received: 0
13 years 2 weeks ago #29509

thanks i will try that. the cart is now working. i deleted all the custom fields and remade them and it now works. must have screwed something up.
thanks again. L

Please Log in or Create an account to join the conversation.

  • Posts: 102
  • Thank you received: 0
13 years 2 weeks ago #29511

thanks nicolas! using that thread i fixed the database and my debug now works!!
awesome.

Please Log in or Create an account to join the conversation.

Time to create page: 0.064 seconds
Powered by Kunena Forum