1. Home
  2. Community
  3. Troubleshooting and Problems
  4. Another mysql error after upgrade

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Another mysql error after upgrade

Troubleshooting and Problems 156 This topic was started by ,


avatar
error 232
From: -
Another mysql error after upgrade

The MySQL database of the IP.Board 3 installation has encountered the following problem:
The MySQL database server has returned 1054: Unknown column 'new_msg' in 'field list' while executing SELECT new_msg FROM ibf_members WHERE name = 'xper' LIMIT 1

SELECT new_msg FROM ibf_members WHERE name = 'xper' LIMIT 1

Please try it in a few minutes again. We apologize for any inconvenience.


Site is down for several hours.

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: Another mysql error after upgrade
avatar
OP 232
From: -
I think I fixed it. Must be SELECT msg_count_new FROM instead of SELECT new_msg.

Thanks.
1 Re: Another mysql error after upgrade
avatar
OP 232
From: -
Thats strange. I tried last night to track it but there is no new_msg in ipb 3uwrapper.

I got error here:

<div style="float: left">
<div>You have <a href="https://www.contentteller.com/{$preferences[ 'website_uwrapper_forumpath' ] }/index.php?act=Msg&CODE=01"><strong>{$new_msg} personal message(s)</strong></a>.

and PHP part:

global $uwrapper, $preferences;
$uwrapper -> bbconnect();
$results = $uwrapper -> bbquery( "SELECT new_msg FROM " . $uwrapper -> bbescape( $preferences[ 'website_uwrapper_prefix' ] ) . "members WHERE name = '" . $uwrapper -> bbescape ( $insert['user_username'] ) ."' LIMIT 1" );
list( $new_msg ) = $uwrapper -> bbrow( $results );
$uwrapper -> bbclose();
1 Re: Another mysql error after upgrade
avatar
Editor
0
From: -
Where do you get this error? I can't find this SQL query in the IPB.Board 3 module.

Perhaps a custom block or other modification?

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.