After upgrade, I get "Called 'db_res' function with erroneous... "

5 posts

My site was just upgraded from Dolphin 7.0.6 to 7.0.7 to 7.0.8. Now, I receive the following message: Database error in (my site) Query: INSERT INTO `sys_ip_members_visits` SET `MemberID` = 'number', `From`='other number', `DateTime`=NOW() Mysql error: Unknown column 'MemberID' in 'field list' Found error in the file '/home/xxxx/public_html/member.php' at line 675. Called 'db_res' function with erroneous argument #0. I've found the error. Unfortunately, I have no clue what to do with it. Any advice would be welcome. [3] => Array ( [file] => /home/xxxx/public_html/member.php [line] => 675 [function] => db_res [args] => Array ( [0] => INSERT INTO `sys_ip_members_visits` SET `MemberID` = 'number', `From`='other number', `DateTime`=NOW() Thank you in advance. JPAres1

Quote · 17 Nov 2011

deano92964Premium

10772 posts

The error says the column MemberID was not found in the table sys_ip_members_visits

This should not be possible as this column exists in all 3 of the dolphin versions you mentioned.

So my best guess is the table was damaged during the upgrade.

Try running the following query in phpMyAdmin to recreate the table.

DROP TABLE IF EXISTS `sys_ip_members_visits`;
CREATE TABLE IF NOT EXISTS `sys_ip_members_visits` (
`ID` int(11) NOT NULL auto_increment,
`MemberID` int(10) unsigned NOT NULL,
`From` int(10) unsigned NOT NULL,
`DateTime` datetime NOT NULL,
PRIMARY KEY (`ID`),
KEY `From` (`From`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

https://www.deanbassett.com

Quote · 17 Nov 2011

JPAres1Advanced

5 posts

So far, so good. Thank you Deano! Appreciate your help!

Quote · 17 Nov 2011

Reply ›

After upgrade, I get "Called 'db_res' function with erroneous... "

Blogs

Help

Product

Company