hi firends.
i have 2 big problems.
------------------------------------------------------------
problem 1 :
after upgrading mybb 1.2.2 to 1.2.3, when i copy any thread, show this error :
MySQL error: 1054
Unknown column 'tid' in 'where clause'
Query: SELECT * FROM mybb_pollvotes WHERE tid = '5170'
----------------------------------------------------------------
problem 2 :
i changed server yesterday. but when users and me login in forum, and show the index.php page and other page, show this error below the footer :
MySQL error: 2006
MySQL server has gone away
Query: UPDATE mybb_users SET lastactive='1173945875', timeonline=timeonline+12 WHERE uid='2'
please help me....
thx to all.
Did you run the upgrade script itself?
For the gone away error:
http://www.mysql.com/doc/G/o/Gone_away.html
http://www.mysql.com/doc/C/o/Common_errors.html
http://www.mysql.com/doc/S/e/Server_parameters.html
http://www.mysql.com/doc/O/p/Option_files.html
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
The most common reason for the MySQL server has gone away error
1. Is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours or 28800 seconds if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld via your server's /etc/my.cnf as well.
2. Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.
i.e. to check mysql uptime, in shell as root user type:
mysqladmin -u root -p version
3. You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row
4. or simply your host restarted mysql.. i'd contact your web host
As for your copy problem try and reupload a fresh inc/class_moderation.php
destroyer Wrote:Did you run the upgrade script itself?
no....
about problem 2, i tell server admin and he say :
your old host , have mysql 4 and your host have mysql 5, you should upgrade your script to solve this problem.
i was upload install folder and run upgrade.php, but nothing change about that problem.
how can, match my database with new mysql version (5) ?
thx to all.
MyBB is already compatible with MySQL 5. Your host is just excusing their server problems.
Tikitiki Wrote:For the gone away error:
http://www.mysql.com/doc/G/o/Gone_away.html
http://www.mysql.com/doc/C/o/Common_errors.html
http://www.mysql.com/doc/S/e/Server_parameters.html
http://www.mysql.com/doc/O/p/Option_files.html
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
The most common reason for the MySQL server has gone away error
1. Is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours or 28800 seconds if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld via your server's /etc/my.cnf as well.
2. Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.
i.e. to check mysql uptime, in shell as root user type:
mysqladmin -u root -p version
3. You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row
4. or simply your host restarted mysql.. i'd contact your web host
As for your copy problem try and reupload a fresh inc/class_moderation.php
thx to you for help, but in problem 2 :
my forum installed in my old host with mysql 4 and php 4.4.4
i was change my host yesterday, and new host have mysql 5 and php 4.4.6
my server admin say about problem 2:
your old host , have mysql 4 and your host have mysql 5, you should upgrade your script to solve this problem.
i was upload install folder and run upgrade.php, but nothing change about that problem.
but , i install fresh mybb in new host , and this problem not show....
i think for solve this problem, i must converting my database to mysql 5 structure.
but i don't know how can do it.....
thx u.
Did you just reupload the upgrade script when you upgraded? You need to overwrite all the changes files since your last version and then run the upgrade script.
Tikitiki Wrote:Did you just reupload the upgrade script when you upgraded? You need to overwrite all the changes files since your last version and then run the upgrade script.
i was upgrading mybb script from 1.2.2 to 1.2.3 in my old host.
and now my script full upgraded.
this problem very antic, because i installed fresh mybb 1.2.3 in new host and have not problem...
my script details in new host:
MyBB version: 1.2.3
DB version: MySQL 5.0.27
PHP version: 4.4.6
my script details in old host:
MyBB version: 1.2.3
DB version: MySQL 4.1.21-standard
PHP version: 4.4.4
do you think this problem for my new host or my script?
and what's your offer for solve this problem?
It's a problem with your new host. MyBB is already compatible with MySQL 5.0.