Error after upgrading to MySQL 4...

[cirisme]

I get the following MySQL error anytime I try to go in my profile:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=2 ORDER BY title
mysql error: Can't create/write to file '/tmp/root-tmp.023872153c765a63/files/#sql557d_3_2.MYI' (Errcode: 13)

mysql error number: 1

Date: Tuesday 26th of August 2003 07:28:37 AM
Script: http://www.theologyweb.com/forum/forum/usercp.php?s=
Referer: http://theologyweb.com/forum/index.php?s=

So, I tried changing the groups of mysqld, but then I couldn't start mysqld. :eek:

So... I reverted to the backup I made, and now we're back to MySQL 3, but I'm still getting this error. :confused:

What can I do?

[cirisme]

Apparently, if you go through and chgrp and chown the appropriate files, it works fine. :)

version 4 of mysqld does not want to start, when I type "safe_mysqld &", I get this and it just sits there:

[1] 25154
[root@theologyweb libexec]# Starting mysqld daemon with databases from /var/lib/mysql
030826 08:28:39 mysqld ended

But when I do that on version 3, it says the same thing(except the mysqld ended line) and returns to normal.

I started it without problems earlier, why is it giving me trouble now? :confused:

Edit: I did shutdown MySQL before attempting to start mysqld.

[eva2000]

checked the file permissions on your vB forum's actual data files *.MYI/frm, MYD files

[cirisme]

Thanks for the reply. I finally found the error, apparently I forgot to update some system files. ;)

[cirisme]

Okay, I have another question. :)

How do I update libmysqlclient.so? I looked at PHPInfo, and it says we're still using 3.23.54 for client API, and I can't find the 4.0.14 version at PHP's site. Where do I get it, and how do I update it?

Thanks in advance.

[eva2000]

you need to recompile PHP --with-mysql=/path/to mysql

like at http://www.vbulletin.com/forum/showpost.php?p=490109&postcount=4

[cirisme]

That did it, thanks!! :)

[cirisme]

Okay, I was hoping that would take care of the database corruption but so far it hasn't. :(

Everyday, at a random time, thread.myi disappears. Yesterday was the worst, it could not be repaired through PHPMyAdmin, and when it was repaired it said that a user had not properly closed the table.

I'm really not wanting to downrade, but I'm afraid that may be the only solution. Any other ideas as to what's causing this? I'm running MySQL 4.0.14, and PHP 4.3.2.

Edit: I had a thought. MySQL is installed at /usr/local/mysql4/, but I didn't move the data from /var/lib/mysql.(that's where MySQL 3 stored its data, MySQL 4 is still accessing that...) Could that cause problems? I ran the user permissions update script. PHP also starts up with warnings, but only after it was recompiled:

Starting httpd: [Fri Aug 29 07:58:30 2003] [warn] module php4_module is already
loaded, skipping
Processing config directory: /etc/appliance/apacheconf
Processing config file: /etc/appliance/apacheconf/apache
PHP Warning: Function registration failed - duplicate name - mysql_connect in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_pconnect in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_close in Un
known on line 0
PHP Warning: Function registration failed - duplicate name - mysql_select_db i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_query in Un
known on line 0
PHP Warning: Function registration failed - duplicate name - mysql_unbuffered_
query in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_db_query in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_list_dbs in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_list_tables
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_list_fields
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_list_proces
ses in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_error in Un
known on line 0
PHP Warning: Function registration failed - duplicate name - mysql_errno in Un
known on line 0
PHP Warning: Function registration failed - duplicate name - mysql_affected_ro
ws in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_insert_id i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_result in U
nknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_num_rows in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_num_fields
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fetch_row i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fetch_array
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fetch_assoc
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fetch_objec
t in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_data_seek i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fetch_lengt
hs in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fetch_field
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_field_seek
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_free_result
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_field_name
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_field_table
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_field_len i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_field_type
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_field_flags
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_escape_stri
ng in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_real_escape
_string in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_stat in Unk
nown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_thread_id i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_client_enco
ding in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_ping in Unk
nown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_get_client_
info in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_get_host_in
fo in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_get_proto_i
nfo in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_get_server_
info in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_info in Unk
nown on line 0
PHP Warning: Function registration failed - duplicate name - mysql in Unknown
on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fieldname i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fieldtable
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fieldlen in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fieldtype i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_fieldflags
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_selectdb in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_freeresult
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_numfields i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_numrows in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_listdbs in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_listtables
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_listfields
in Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_db_name in
Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_dbname in U
nknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_tablename i
n Unknown on line 0
PHP Warning: Function registration failed - duplicate name - mysql_table_name
in Unknown on line 0
PHP Warning: mysql: Unable to register functions, unable to load in Unknown o
n line 0
Processing config directory: /etc/appliance/apacheconf
Processing config file: /etc/appliance/apacheconf/apache
Processing config directory: /etc/httpd/conf/virtual
Processing config file: /etc/httpd/conf/virtual/site1
Processing config directory: /etc/httpd/conf/site1
Processing config file: /etc/httpd/conf/site1/cgi
Processing config file: /etc/httpd/conf/site1/mod_perl
Processing config file: /etc/httpd/conf/site1/sqmail
Processing config file: /etc/httpd/conf/site1/ssi
Processing config file: /etc/httpd/conf/virtual/site1.ssl
[ OK ]

[cirisme]

Okay, due to daily crashes, I've downgraded to 3.23.57 based on instructions at RackShack (http://forum.rackshack.net/showthread.php?threadid=18491).

But where are the MySQL files I need to recompile PHP against? I only have those RPMs...