[fixed] Internal server error on checkout

[Phil_hunt]

Hi there,

I am using 2.0.0-RC-2H with joomla 1.7.1 but since the update I get a 500 error whenever I hit the show cart link. It all worked fine before the update, can't get any useful debug information because it crashes out. Any help would be greatly appreciated.  http://angel-delight.co.uk/

[PRO]

did you disable all 1.1 plugins, and modules?

[Phil_hunt]

Thanks for the prompt response. I upgraded from 1.9.8G. Sorry, should've said.

[Phil_hunt]

Turns out it's a template issue. Funny though, didn't work with the beez template either. I know it's off topic but can anyone recommend a good template?

[PRO]

Did you upgrade the tables after upgrading?

Renew config by file?

I have it working on Beez 20

[Phil_hunt]

Yep. Did all that. The only template that works for me is one called hathor and that crashes with an internal server error when I enter my address, 2nd stage of checkout. The other 5 I've tried crash when I click show cart.

[PRO]

hathor is a backend template

[Phil_hunt]

Sorry, I'm an idiot, looked at the wrong one on the template page, it was siteground j1.6-10. I tried to update to vm2.0i without rectifying the problem and now all I get is an angry red page with the following error:
500 - JDatabaseMySQL::query: 1146 - Table 'angelde1.jos_virtuemart_configs' doesn't exist SQL=DELETE FROM `jos_virtuemart_configs` WHERE `virtuemart_config_id`=1.

[Milbo]

500 - JDatabaseMySQL::query: 1146 - Table 'angelde1.jos_virtuemart_configs' doesn't exist SQL=DELETE FROM `jos_virtuemart_configs` WHERE `virtuemart_config_id`=1.

This problem is fixed in the svn,.. joomla throws an error, when you delete something which is not there. But where do you get the error?

Edit: I took a look on your page and found another bug to fix, thanks is done :-).

[Phil_hunt]

Think it started when I updated the tables after updating to 2.0i. I can access the joomla backend but when I go to virtuemart control panel I get this:

500 - An error has occurred.
JDatabaseMySQL::query: 1146 - Table 'angelde1.jos_virtuemart_configs' doesn't exist SQL=DELETE FROM `jos_virtuemart_configs` WHERE `virtuemart_config_id`=1

Return to Control Panel

Call stack
#   Function   Location
1   JAdministrator->dispatch()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/index.php:47
2   JComponentHelper::renderComponent()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/includes/application.php:153
3   require_once()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/libraries/joomla/application/component/helper.php:156
4   VmConfig::loadConfig()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/components/com_virtuemart/admin.virtuemart.php:27
5   VmConfig::installVMconfig()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/components/com_virtuemart/helpers/config.php:315
6   JDatabaseMySQL->query()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/components/com_virtuemart/helpers/config.php:523
7   JError::raiseError()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/libraries/joomla/database/database/mysql.php:512
8   JError::raise()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/libraries/joomla/error/error.php:250
Errors

JDatabaseMySQL::query: 1146 - Table 'angelde1.jos_virtuemart_configs' doesn't exist SQL=DELETE FROM `jos_virtuemart_configs` WHERE `virtuemart_config_id`=1
Information


Backtrace

Call stack
#   Function   Location
1   JAdministrator->dispatch()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/index.php:47
2   JComponentHelper::renderComponent()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/includes/application.php:153
3   require_once()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/libraries/joomla/application/component/helper.php:156
4   VmConfig::loadConfig()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/components/com_virtuemart/admin.virtuemart.php:27
5   VmConfig::installVMconfig()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/components/com_virtuemart/helpers/config.php:315
6   JDatabaseMySQL->query()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/administrator/components/com_virtuemart/helpers/config.php:523
7   JError::raiseError()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/libraries/joomla/database/database/mysql.php:512
8   JError::raise()   /mnt/data/vhosts/angel-delight.co.uk/httpdocs/libraries/joomla/error/error.php:250
Profile Information

Application 0.001 seconds (+0.001); 1.30 MB (+1.302) - afterLoad
Application 0.064 seconds (+0.063); 6.13 MB (+4.831) - afterInitialise
Application 0.065 seconds (+0.000); 6.13 MB (+0.000) - afterRoute
Memory Usage

7.49 MB (7,853,464 Bytes)
7 Queries Logged

SELECT `data`
  FROM `ngl_session`
  WHERE `session_id` = 'ib6qmlh987skkte5dhtd3pa001'
SELECT template, s.params
  FROM ngl_template_styles as s
  LEFT JOIN ngl_extensions as e
  ON e.type='template'
  AND e.element=s.template
  AND e.client_id=s.client_id
  WHERE s.client_id = 1
  AND home = 1
  ORDER BY home
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM ngl_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_virtuemart'
SELECT `config`
  FROM `ngl_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1"
CREATE TABLE IF NOT EXISTS `ngl_virtuemart_configs` ( `virtuemart_config_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `config` text, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT 0, `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT 0, `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`virtuemart_config_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='Holds configuration settings' AUTO_INCREMENT=1 ;
DELETE
  FROM `jos_virtuemart_configs`
  WHERE `virtuemart_config_id`=1
UPDATE `ngl_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1318975300;s:18:\"session.timer.last\";i:1318975714;s:17:\"session.timer.now\";i:1318975724;s:22:\"session.client.browser\";s:106:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:8:\"angeldel\";s:5:\"email\";s:24:\"shop@angel-delight.co.uk\";s:8:\"password\";s:58:\"c2d8764488475ec0d73aa7bf353a6820:i7gcjlM^YTYZmBVPJVMlqalii\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-08-21 15:15:54\";s:13:\"lastvisitDate\";s:19:\"2011-10-18 20:20:43\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"101482e611ce60267897e11e41693902\";}',    `time` = 1318975724
  WHERE `session_id` = 'ib6qmlh987skkte5dhtd3pa001'
7 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1 × SELECT `config` FROM `ngl_virtuemart_configs`
1 × SELECT extension_id AS "id", element AS "option", params, enabled FROM ngl_extensions
1 × SELECT template, s.params FROM ngl_template_styles as s LEFT JOIN ngl_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id
1 × SELECT `data` FROM `ngl_session`
OTHER Tables:

1 × UPDATE `ngl_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1318975300;s:18:\"session.timer.last\";i:1318975714;s:17:\"session.timer.now\";i:1318975724;s:22:\"session.client.browser\";s:106:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/14.0.835.202 Safari/535.1\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:8:\"angeldel\";s:5:\"email\";s:24:\"shop@angel-delight.co.uk\";s:8:\"password\";s:58:\"c2d8764488475ec0d73aa7bf353a6820:i7gcjlM^YTYZmBVPJVMlqalii\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-08-21 15:15:54\";s:13:\"lastvisitDate\";s:19:\"2011-10-18 20:20:43\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"101482e611ce60267897e11e41693902\";}', `time` = 1318975724
1 × DELETE FROM `jos_virtuemart_configs`
1 × CREATE TABLE IF NOT EXISTS `ngl_virtuemart_configs` ( `virtuemart_config_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `config` text, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT 0, `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT 0, `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`virtuemart_config_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='Holds configuration settings' AUTO_INCREMENT=1

[Phil_hunt]

I noticed that my database prefixes were different from the default jos_ so I made a dummy table for jos_virtuemart_configs with an entry for virtuemart_config_id with a value of one and everything seems to be working fine.

[Milbo]

yeah, problem is now fixed.