News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Database Error

Started by andrewill, August 18, 2014, 02:14:48 PM

Previous topic - Next topic

andrewill

Alright. I did it again.


Now it appears on the forums that the topics exist, but it really doesn't.

You can see what I mean here:-

www.la-crp.tk

Kindred

can't access the site without a login....

also - check the message table again...   if the topics are there but the messages are not, then you got the topics table uploaded, but not the messages table
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

andrewill


Kindred

Quote from: Kindred on August 30, 2014, 03:16:47 PM
also - check the message table again...   if the topics are there but the messages are not, then you got the topics table uploaded, but not the messages table
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

andrewill

Which is....


smf_messages and?

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

andrewill

All Good.

Last question. My Admin Status Was Removed, How Do I Restore It?


andrewill

And That Does It. <3 Thank you.

kat

WoOt! :)

Glad we got there, in the end.

aegersz

my HOST pointed me to this when i got the dreaded "Database Error" > http://php.about.com/od/mysqladministration/qt/repair_mysql.
The configuration of my Linux VPS (SMF 2.0 with 160+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Kindred

aegersz,

this post was 2 years old...


additionally, repair only works if the database has a broken table...     in most cases, (as in this case) the database error is something else entirely -- and the repair would do absolutely nothing.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

aegersz

Quote from: Kindred on July 23, 2015, 09:19:44 AM
aegersz,

this post was 2 years old...


additionally, repair only works if the database has a broken table...     in most cases, (as in this case) the database error is something else entirely -- and the repair would do absolutely nothing.

i see. i had it once and i restored the database. but it haunts me. thanks.
The configuration of my Linux VPS (SMF 2.0 with 160+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Advertisement: