News:

Wondering if this will always be free?  See why free is better.

Main Menu

Database mess :S

Started by Bounty_y2k, June 17, 2013, 10:49:59 PM

Previous topic - Next topic

Bounty_y2k

Okay this one is killing me :S
I have a forum witch I want to move to another hosting. So I downloaded smf 2.0.4 again and installed it on host2. It works fine until I import the database from host1.
When I import the old database (from host1) I get this error when accessing the forums:
QuoteUnable to load Themes/default/Errors.template.php!
And when I tried with new database It works fine...:S
Help? :P

P.S. The file that is "Missing" is actually there.

LiroyvH

Did you run repair_settings.php?
Local (absolute) paths might be set wrong.
((U + C + I)x(10 − S)) / 20xAx1 / (1 − sin(F / 10))
President/CEO of Simple Machines - Server Manager
Please do not PM for support - anything else is usually OK.

Bounty_y2k

I did that already and i fixed all the paths,they all look correct.
As I said the forum works fine with newly created db,as soon as I switch it to my old one it gets an error.

Before I wanted to move the forums I installed SmfShoutbox..maybe that is causing the problem?

Bigguy

Have you checked permissions on the file. ???

Bounty_y2k

I doubt that's the problem but I will check...
All permissions in the folder are -644,that should be fine,right?

Kill Em All

Folders should be 755 while files should be 644. How did you backup your database? It's possible that the backup is not a complete backup and is only partial if you used the tool in the SMF admin panel.


My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

Bounty_y2k

QuoteFolders should be 755 while files should be 644.
They are like that.
QuoteHow did you backup your database? It's possible that the backup is not a complete backup and is only partial if you used the tool in the SMF admin panel.
I did the backup from PhpMyAdmin (Exporting the db) I tried .zip and .sql format,they give the same results.
I didn't mess with other options I have left them by default. Maybe that is the problem?
Can I export the db with only users,topic and posts and similar info,without settings or something like that? (I could try with that)

Sir Osis of Liver


Sounds like you exported the db correctly.  There's nothing in smf_settings that would cause that error.  Are you importing it into completely clean install, no mods or edits?

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Bounty_y2k

Yeah,completly clean. But i noticed these tables in the db "smf_shoutbox,smf_shoutbox_ban and smf_shoutbox_settings". (Witch ,I guess,don't exist in the clean version since its a mod )

Sir Osis of Liver


Have you tried uninstalling the shoutbox mod in the old install before you export the db?  Some mods will leave db tables behind when they're uninstalled, but the orphan tables are ignored.

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Bounty_y2k

Uhh..you see the reason why am I changing the hosting in the first place is that old one was bugged a lot and on top of that i managed to break it somehow xD So you see I cant access the admin panel of smf but I have access to CPanel so I could delete these tables manually...
One more thing I noticed between these databases is that my old one has "latin1_swedish_ci" collation in every table and the database of the clean version has "latin1_general_ci". Could that be the problem?
By the way thanks for helping :)

Sir Osis of Liver

latin1_swedish_ci is the collation for all of my SMF databases.  Try changing the collation on the clean db and see if it creates the problem.  Shouldn't.

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Sir Osis of Liver


You may have two separate problems here.  Looks like Errors.template.php is only loaded when there's an error.  The new install works with the new db because it doesn't throw an error.  It doesn't work with the old db because something's wrong with the db, an error is generated, and it tries to load the template to display the error.  The template fails to load because there's something wrong with the new install.

If nothing else works, I would try deleting the new install and reinstalling it from scratch.

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

MrPhil

latin1_general_ci and latin1_swedish_ci are the same, for all intents and purposes (perhaps not, if you are working with Scandinavian languages). The important thing is that they are the same encoding (Latin-1, aka ISO-8859-1, Western European, etc.). They are both "case insensitive" for sorting purposes. The only difference is the collation order for sorting of certain special characters and character sequences.

MySQL defaults to "swedish" because it was originally developed in Sweden. For English and Western European languages, it makes no real difference. Your host may have changed the default from swedish collation to general.

Bounty_y2k

Quotelatin1_swedish_ci is the collation for all of my SMF databases.  Try changing the collation on the clean db and see if it creates the problem.  Shouldn't.
Just tried,It doesn't. Its the same as Mr.Phil said.

QuoteIf nothing else works, I would try deleting the new install and reinstalling it from scratch.
I am doing that. I mean this is that clean version on witch i want to import the DB.

Whatever I do I get that same error. I just tried to install the theme I had before and the shoutbox mod I installed before. And it was okay,but soon as I switched the database I get the error.
Is there an option when exporting the db to export only important stuff,without any settings?

Bounty_y2k

Okay I think I might found something..
I checked log in ACP of smf (while on clean db) and I got a lot of errors showing this:
http://mysite.com/index.php?http://mysite.com/Unable to load Themes/default/Errors.template.php!
http://mysite.com/index.php?http://mysite.com/8: Undefined index: error_occuredFile: /home/a7026556/public_html/Sources/Errors.php Line:294/187
http://mysite.com/index.php?http://mysite.com/8: Undefined index: theme_language_errorFile: /home/a7026556/public_html/Sources/Load.php
Line: 1953

Etc...
I was always using only English on my forums I didn't install any other languages or anything as I said on my old forum all i had installed was 1 theme and smf shoutbox.
(Sorry for double posting)

Kindred

wait....   What theme are you using?

http://mysite.com/index.php?http://mysite.com/

this is wrong....   you can't call the url as an argument to the url....
Сл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."

Bounty_y2k

I am using Dhari theme,witch never before gave an error. Uhm..where i can change these urls?

Kindred

I don't know...   I don't know what is generating that bad url... but something is...
Сл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."

Bounty_y2k

I just got this email.
QuoteThere has been a problem with the database!

This is a notice email to let you know that SMF could not connect to the database, contact your host if this continues.

And I have checked whole database row by row and I cant seem to find any problems...

Advertisement: