Error as following:
Database error in vBulletin 2.2.4:
Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND fromuserid<>12
mysql error: Can't open file: 'privatemessage.MYD'. (errno: 145)
mysql error number: 1016
When I type repair.php, it goes:
CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:
Second, I don't know how to use telnet, need server support???
Last month my forum get hack by someone, this guy copy my administartor user from database, and there are one invisible adminstator in my forum with his own nick and I am worry about I loss my database adn donwload by this guy.
Your hints liks the following:
mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql
How do I type the correct string:
Need space after mysqldump then add "--opt"?
What is -uUSERNAME and -p, "-u" and "-p" stand for what??
/path/to/dump.sql, can I type like this /c:/dump.sql
After I execute mysql.exe in bin directory, then I don't know what's the next step. PLease help
I am the admin of the server, and I can active telnet, please let me know how to use this service, is it go to DOS and key in the synatx as you provide??
Can not load iconv or recode extension needed for charset conversion, configure php to allow using these extensions or disable charset conversion in phpMyAdmin.
^--- and? Did you set up php accordingly ?
It's fun, finally I get help from senior members instead of Vbulletin Team, Good for you!!!
Do check my last two threads, the time difference is over 36 hours, now the persons reply my post is you guys, not Vbulletin team.
I do setup the whole thing for phpMyAdmin, when I go to run it, it shows the error as below:
Can not load iconv or recode extension needed for charset conversion, configure php to allow using these extensions or disable charset conversion in phpMyAdmin.
This just tells me that vBulletin isn't the problem here, and therefor it doesn't suck.
It just tells me that your setup of the web server, using PHP and MySQL as back-end has some configuration issues. Which are your concern, and not vBulletin's ?
I'm assuming you still don't have a license... so you can't get any support. But, if you do have a license - enter you license info at http://www.vbulletin.com/members/forums.php and post in the correct forum. :)
Please explain, thank you.
Error in start page:
Can not load iconv or recode extension needed for charset conversion, configure php to allow using these extensions or disable charset conversion in phpMyAdmin.
As I said in another post, ( http://www.vbulletin.com/forum/showthread.php?s=&threadid=49256 ) Day 7 will be either on Saturday or Sunday (depending on if they count Jun 29 or June 30 as Day 1)
If you don't hear anything from them soon, send an email to support@vbulletin.com, I'm sure they'd be glad to help you.
Please check when I post the thread. No one take care paid client, I am really don't understand why I go to pay for the license, it's for what???
Everyday I got the same SQL error, it's no difference than those non-license product. Now I am very upset in a trap.
Database error in vBulletin 2.2.6:
Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'user.MYD'. (errno: 145)
mysql error number: 1016
No one answer, no supports, same SQL errors everyday, Vbulletin SUCKs!!!
My last post is July 19, 2002, anyone is working???? addressing this error above, if you're getting the error everyday then you may have hardware problems i.e. bad memory or hard drive
your vB database shouldn't be corrupting like this - not by itself anyway...
phpmyadmin is not the only way to repair corruption in the user table there are 4 ways of doing this
1. via phpmyadmin
using query
REPAIR TABLE user;
2. or using mysqlcheck repair for 3.23.38 and above
i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:
mysqlcheck -r -u mysqlusername -p databasename
3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :
myisamchk -r -u root -p databasename
option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.
Do check my last two threads, the time difference is over 36 hours, now the persons reply my post is you guys, not Vbulletin team.
I do setup the whole thing for phpMyAdmin, when I go to run it, it shows the error as below:
Can not load iconv or recode extension needed for charset conversion, configure php to allow using these extensions or disable charset conversion in phpMyAdmin.
Originally posted by xiphoid
Error in start page:
Can not load iconv or recode extension needed for charset conversion, configure php to allow using these extensions or disable charset conversion in phpMyAdmin.
^--- and? Did you set up php accordingly ?
As for the CGI error it sounds like your server is running PHP in CGI mode. Do you have a phpinfo.php file? If not create a text file with this content:
phpinfo();
?>Name it 'phpinfo.php' then upload it to your forum directory and post the URL here.
As for telnet, you will have to ask your host if they provide this (or ssh) and if so, get your user name and password from them.
Man, Vbulletin is not a stand alone Forum, at least it must run with PHP+MYSQL, am I right. Now I am not trying to say who is right or who is wrong, I only need to know how can I secure my database and fixing those database error, that's it.
vBulletin requires a web server, php and mysql database. And preferibly one web server that can work with php and mysql.
I always use (no matter which platform) Apache 1,x , PHP 4.2.x and MySQL (latest stable release) with vB 2.2.6
Hey
a vB team member replied within 24 hours
actually, within 12 working hours.
Try to get that kind of support from microsoft. IF they don't charge you for it :)
This has only started to happen since I started taking aspirin before logging into this board. It doesn't seem to happen if I just take aspirin, and then not log in to this board.
So, I think it is this board.
Help me. I'm watching the clock for a quick response. Thanks
Everyday I got the same SQL error, it's no difference than those non-license product. Now I am very upset in a trap.
Database error in vBulletin 2.2.6:
Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'user.MYD'. (errno: 145)
mysql error number: 1016
No one answer, no supports, same SQL errors everyday, Vbulletin SUCKs!!!
My last post is July 19, 2002, anyone is working????
Database error in vBulletin Control Panel 2.2.6:
Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
mysql error: Can't open file: 'user.MYD'. (errno: 145)
mysql error number: 1016
Please help. Can't use repair.php anymore. I just don't know why the forum always has this kind of database error, can you let me know why???
Error as following:
Error 1
Database error in vBulletin 2.2.4:
Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND fromuserid<>12
mysql error: Can't open file: 'privatemessage.MYD'. (errno: 145)
mysql error number: 1016
Error 2
Database error in vBulletin 2.2.4:
Invalid SQL: SELECT privatemessage.*,touser.username AS tousername,fromuser.username AS fromusername,icon.title AS icontitle,icon.iconpath FROM privatemessage,user AS touser,user AS fromuser LEFT JOIN icon ON icon.iconid=privatemessage.iconid WHERE privatemessage.userid='1' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 AND privatemessage.fromuserid<>12 ORDER BY dateline DESC
mysql error: Can't open file: 'privatemessage.MYD'. (errno: 145)
mysql error number: 1016
Question 1
How to back up database and upgrade to v2.2.6?? I can't find the upgrade pack.
2. USERNAME is your $dbusername, and '-p' means that you will be prompted for the $dbpassword after entering this command (you use the same values as in your config.php file)
3. Actually you could just enter 'dump.sql' if you want the file to be saved in the current directory you are in. Otherwise to ssave it in the root directory, use '/dump.sql'
http://www.vbulletin.com/forum/showthread.php?s=&threadid=18558
REPAIR TABLE user;
If you are using CPanel and still can not find it, please let me know and I will help you further, although it should be found as described above.
- SaintDog
1) Download phpMyAdmin ( www.phpmyadmin.net )
2) Open up the config.inc file.
On the 26th line
Write the complete path to phpMyAdmin (where it will be located on your server)
On line 36
Enter the your MySQL hostname. (This should be localhost)
Line 45
Enter your MySQL Username
Line 46
Enter your password for the username you used.
That should be all... Next, upload all your files and try to run it.
Please reply, thank you
more on table corruption and possible causes http://mysql.he.net/doc/C/o/Corrupted_MyISAM_tables.html
http://mysql.he.net/doc/C/r/Crashing.html
1. Change all the passwords of your Admins, Super Moderators and Moderators.
2. Use htaccess to protect your'admin' and 'mod' directories. Here are some instructions on doing this:
http://faq.clever.net/htaccess.htm
3. Remove any Admin users that you do not know.
As for telnet, assuming you are running Windows, just go into Start -> Run, and type:
telnet yourserver.com
You will need to use your username and password for that server inh order to log in.
Even check in mySQL, bin folder, can't locate it.
Told you, paid member like me just being ignored. What a joke!!!
You should not expect support on how to install phpMyAdmin since that is not our product. You may very well receive assistance regarding it but you seem to be having issues with not receiving official support on non jelsoft products. That doesn't make any sense?!?
If you require answers to vBulletin related problems, please submit a support ticket as support is not guaranteed through the forums.
Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:
repair.php?html=1&check=1
It everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report ok.
Backup: http://www.vbulletin.com/manual/movingservers.html
Upgrade: http://www.vbulletin.com/members/upgrade.html
#If you have any other info about this subject , Please add it free.# |