database error, users and i cant save anything

**badawidollah** · Fri 9 Oct '09, 6:34am

<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://www.nusantaraku.org/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The FORUM COMPUTER, HOSTING, SERVER, BLOG, FREE TOOLS DAN SOFTWARE, WEBMASTER, INTERNET, VPS DAN DEDICATED SERVER, JAWATAN KOSONG, BEASISWA, JUAL BELI, PINJAMAN, TANAH, RUMAH, APARTEMENT, CONDO, HOTEL, TRAVEL, CREDIT CARD, SPORT, BOLA, TECHNOLOGY, FOREX, MIRC, GAMBAR, MUZIK DAN VIDEO, ISLAM, CERITA, PERUBATAN, PENDIDIKAN, JOURNAL, KESIHATAN, HACKING, TUTORIAL, RESIPI, NASIONAL, RAKYAT, MALAYSIA, INDONESIA, THAILAND, SINGAPURA DAN BRUNEI database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">www.nusantaraku.org</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The www.nusantaraku.org forum technical staff have been notified of the error, though you may <a href="mailto:[email protected]">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td>
</tr>
</table>

<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT title
FROM usertitle
WHERE minposts <= 8
ORDER BY minposts DESC;

MySQL Error : Table 'tonop_forum5.usertitle' doesn't exist
Error Number : 1146
Request Date : Friday, October 9th 2009 @ 10:32:07 AM
Error Date : Friday, October 9th 2009 @ 10:32:07 AM
Script : http://www.nusantaraku.org/inlinemod...p;postids=1933
Referrer : http://www.nusantaraku.org/inlinemod...did=481&p=
IP Address : 60.53.225.192
Username : administrator
Classname : vB_Database
MySQL Version : 5.0.81-community</textarea></form>

</body>

**Lynne** · Fri 9 Oct '09, 6:47am

usertitle is a standard vbulletin table. Can you look in your database and see if it is there? (You should also use code tags when posting code.)

**badawidollah** · Fri 9 Oct '09, 7:01am

Originally posted by Lynne

usertitle is a standard vbulletin table. Can you look in your database and see if it is there? (You should also use code tags when posting code.)

i found it
using cpanel
thanks

**badawidollah** · Fri 9 Oct '09, 7:16am

Originally posted by Lynne

usertitle is a standard vbulletin table. Can you look in your database and see if it is there? (You should also use code tags when posting code.)

SELECT COUNT(*) AS `Rows`, `usertitle` FROM `user` GROUP BY `usertitle` ORDER BY `usertitle`

what to do to repair my database
i found that on my usertitle

**badawidollah** · Fri 9 Oct '09, 7:39am

updated...

please somebody help me

**Lynne** · Fri 9 Oct '09, 7:42am

So the usertitle table does exist? Have you tried to repair the table (although if that was the issue, it would say that).

And what is that second query supposed to be or show? That is talking about the user table (which has a column named usertitle), not the usertitle table.

**badawidollah** · Fri 9 Oct '09, 7:47am

Originally posted by Lynne

So the usertitle table does exist? Have you tried to repair the table (although if that was the issue, it would say that).

And what is that second query supposed to be or show? That is talking about the user table (which has a column named usertitle), not the usertitle table.

user Check Status: OK user Optimize Status: OK

**Lynne** · Fri 9 Oct '09, 7:55am

NOT the user table. I am talking about the usertitle table. It should be a separate table.

If you don't have a usertitle table, this is from the mysql-schema file:

Code:

CREATE TABLE " . TABLE_PREFIX . "usertitle (
    usertitleid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    minposts INT UNSIGNED NOT NULL DEFAULT '0',
    title CHAR(250) NOT NULL DEFAULT '',
    PRIMARY KEY (usertitleid)

**badawidollah** · Fri 9 Oct '09, 8:23am

Originally posted by Lynne

NOT the user table. I am talking about the usertitle table. It should be a separate table.

If you don't have a usertitle table, this is from the mysql-schema file:

Code:

CREATE TABLE " . TABLE_PREFIX . "usertitle (
    usertitleid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
    minposts INT UNSIGNED NOT NULL DEFAULT '0',
    title CHAR(250) NOT NULL DEFAULT '',
    PRIMARY KEY (usertitleid)

i changed it to
ALTER TABLE `user` CHANGE `usertitle` `usertitle` SMALLINT( 250 ) NOT NULL

before it the "SMALLINT" was char

**Lynne** · Fri 9 Oct '09, 8:40am

My user table has usertitle as a varchar(250). But again, why are you talking about the user table? It isn't the user table that is the problem.

**badawidollah** · Fri 9 Oct '09, 8:58am

Originally posted by Lynne

My user table has usertitle as a varchar(250). But again, why are you talking about the user table? It isn't the user table that is the problem.

wait
i am restoring my database.
i am only a newbie without experince in database or vbulletin
it s difficult for me

**badawidollah** · Fri 9 Oct '09, 12:03pm

fixed
my usertitle was gone

vBulletin 3 End of Life

database error, users and i cant save anything

database error, users and i cant save anything

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment