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

QuoteDownload the large upgrade package for the exact version of SMF that you're using from the download site. Be sure to select your current version of SMF from the drop-down list next to "Select Version".

Well, I chose 2.0.8 From the drop down list. But there aren't files for that version.

What do I do? :S

kat


Kindred

I wouldn't say that the page was butchered, K@... looks like it was cleaned up and more detailed information added :D
Сл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."

kat

As discretion is the better part of valour...



;)

andrewill

#24
Nothing changed except that I have another error now!

Fatal error: Call to undefined function get2by2host_copyright() in /home/FTPUSER/public_html/Sources/Load.php(2151) : eval()'d code on line 294


Got a backup tho

Kindred

well....   your obviously did NOT load a full set of clean files...  because that error is due to a mod which (since presumably SOME of the files were replaced) is not missing the rest of its code.
Сл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

Did it again.

No changes.

kat

OK... That "eval" thing could be playing tricks on the error message.

Go to Admin>Config>Server settings and "Disable evaluation of templates".

That should show you the real error.

andrewill

Done

Now its:-

Fatal error: Call to undefined function get2by2host_copyright() in /home/FTPUSER/public_html/Themes/relax/index.template.php on line 294

kat

Ah. When you uploaded a new set of files, you didn't upload a new set of files for that theme.

If you switch to the SMF default theme, everything should work.

Then, you can go to Admin, delete the theme, then install a virgin copy.

Or, you could attach a copy of the theme's index.template.php to your next post and we can remove the offending section of code. (Or, of course, you could do that, yourself. :)

If you have other themes, they might have the same problem...

As it happens, I can see your forum. http://www.produo-gaming.tk/index.php

But, the error appears, at the bottom.

andrewill

I'll do that tomorrow, cause i'm awfully tired right now...




As of now,

I just added one more error to my forums. You sure the solution stated above will fix all the 3 errors which are as follows:-


Quote from: andrewill on August 18, 2014, 02:14:48 PM
"Database Error
Please try again. If you come back to this error screen, report the error to an administrator."

Quote from: andrewill on August 18, 2014, 02:14:48 PM"Unknown column 'bg.name' in 'field list'
File: /home/FTPUSERNAME/public_html/Sources/Profile-View.php
Line: 399"

Quote from: andrewill on August 20, 2014, 04:14:29 PM
Fatal error: Call to undefined function get2by2host_copyright() in /home/FTPUSER/public_html/Themes/relax/index.template.php on line 294


Kindred

well, you don't get the first two errors any more, do you?
Сл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

even after you loaded a clean version of your custom theme?

Seriously...   there is no way that ANY of those errors will happen if you actually loaded a fresh set of files for both SMF and your theme.

Сл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

I managed to get rid of the theme error, but the rest still remain.

kat

"Database Error
Please try again. If you come back to this error screen, report the error to an administrator."

Is that all the time? Or, is it intermittent?

I'd try this, if I got that error:

http://wiki.simplemachines.org/smf/Repair_settings.php

Although, quite what you did, to screw the database conection, I couldn't even begin to speculate upon...

Unknown column 'bg.name' in 'field list'
File: /home/FTPUSERNAME/public_html/Sources/Profile-View.php
Line: 399"

"bg.name" only appears in a virgin Profile-View.php file, in one place, on line 207. So, did you really upload a full set of files?

Kindred

K@,

it is unlikely that repair_settings will fix this.
The database error occurs mid page, not at the page load...   which means that some mod is attempting a database call within his template -- (which is wrong to begin with)

Hence my continuing statement that he has not actually loaded a clean set of files.
Сл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."

kat

"Database Error. Please try again. If you come back to this error screen, report the error to an administrator." made me think that he might've got the database details screwed, somehow.

How, I couldn't even begin to speculate. But, I have to say, a lot of what's gone-on, here, has been a bit... well... weird.

andrewill

I have tried repair_settings.php

And NOWPE, nothing changed. :S

kat

Quote from: K@ on August 21, 2014, 10:01:10 AM"bg.name" only appears in a virgin Profile-View.php file, in one place, on line 207. So, did you really upload a full set of files?

If I go to http://www.produo-gaming.tk/index.php I get the error.

BUT... If I go to http://www.produo-gaming.tk/index.php?theme=1 I can get in.

Advertisement: