Getting this database Error...

[Rolodex]

Thanks for responding Paul, I went into phpMyAdmin and changed the contents of one table latin-general c1 to latin-sweedish c1 and the error went away! ...

[Rolodex]

In my adminCP:
--------------

Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT adminmessage.adminmessageid
FROM adminmessage AS adminmessage
INNER JOIN...

[Rolodex]

Do you have a replacement for the "Biggrin" and the "embarrassed" image?

[Rolodex]

Hi Zac,

If you forgotten, when you empty the bbcode table, there's nothing in the bbcode manager. As I wrote above, that's what I did, and this hack tag still remains. All of the old files...

[Rolodex]

To whom it may concern,

I have upgraded my forum from v2.30 to v3.03, and there seems to be a problem with my BBCode. I had a hack that installed another set of BBCodes to use. Well, this...

[Rolodex]

Maybe I haven't explained my problem well enough ... you see, I have no BBCode in the BBCodes Manager to edit. There's none, and I need to know how can I get the original bbcode back into the BBCode...

[Rolodex]

What files?

I've replaced the bbcode.php file twice ......

[Rolodex]

Can Someone send me the SQL for this table, so I can import it into my BBCodes table?

Thanks!

[Rolodex]

I installed a hack while I had vb 2.30 installed (upgraded to vB v3.0.3) which modified the bbcodes table, and I emptied the table in MySQL to remove the hack. Now all of the BBCodes which I could see...

[Rolodex]

Ok ... my only concerns are the attachments that are already there. Will their be a conflict exporting them from the database? Reason why I ask is that the new version allows you to export attachments...

[Rolodex]

Zac,

Will I have to manually remove all of the tables in the database for hacks that required a database modification?

[Rolodex]

I kinda figured that you misinterpret that line ... i'm still using the unhacked copy and the numbers are still resetting themselves. About vBadvanced, what does this program do?

[Rolodex]

I don't know anything about vBadvanced ... what is it used for?

I'm right now trying to test to see if there's another hack (or something inside my database) that might be causing this problem....

[Rolodex]

I ran the unhacked index.php for a whole day, and also ran the query you suggested right after replacing the hacked version. The query did reset the two numbers successfully, but everytime someone logs...

[Rolodex]

I just tried it, and the problem remains.

[Rolodex]

I've had this problem for quite awhile and I can't seem to figure out why this all of a sudden started happening. These are the variables below:

$recordusers = $maxusers[0];
$recorddate...

[Rolodex]

I agree ... I'd say 300-500 Mb would be more sufficient.

[Rolodex]

I don't like the layout ... these threads are quite confusing. I'd rather stay with vB 2.30.

[Rolodex]

I'm sure someone here knows whats going on .. let us know!

[Rolodex]

Sounds too good to be true ... i'd like to know about this host as well!