FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Help: SQL error after uploading new files(thread updated)





Helios
Ive installed a phpBB board and then ive downloaded the config to my computer and copied it to the directory with the phpBB files..

I did that to install mods on my system and then upload it to my account(and install additional SQL tables if needed).

I did that.. installed about 6 mods and uploaded the new files to my account.

now when I try to go to the index.php this error shows up:
Code:
phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table '[name_of_database].[my_prefix]_config' doesn't exist

SELECT * FROM [my_prefix]_config

Line : 219
File : common.php


the thing is that ive checked in phpMyAdmin and the table [my_prefix]_config does EXIST!!

what should I do???

about [my_prefix].. i dont wanna show my real prefix for security reasons =P


:::::: update ::::::::::

well ive installed the baord again(from the original files) and uploaded all of the moded files.. ran 2 sql quries and everything went ok..
now i enter the board and everything seems to be alright..
BUT when ive entered the Admin Panel.. on the left frame(where are all the categories and links to the admin config pages) this error appeared instead all of the links:

Code:

Parse error: parse error, unexpected '}' in /home/helios/public_html/board/includes/template.php(127) : eval()'d code on line 26


this file wasnt moded by me at all, i didnt touch it..
and line 26 is where the /* comments */ from phpBB team.. no code there at all..
what should I do now???

this is the code from template.php(127)
line 127 is the middle line:
Code:

      // Run the compiled code.
      eval($this->compiled_code[$handle]);
      return true;
   }
[/quote]
Maka
Use fantastico to install it for you. Much easier.
Helios
mm.. I install a hebrew translated phpBB..
and I have no problems with the installetion at all.
mOrpheuS
I've downloaded-modified-uploaded my phpBB installation (and many other scripts) by hand several times and it all went pretty smooth.

The only time I ran into trouble was when I modified any php file from the cPanel editor.
If you have done that, then I'd suggest you modify any files locally and upload them later.

I don't see why a installation should run perfectly at your local machine and not at the server if you uplolad the same files and replicate the same database.

Don't use cPanel editor for php editing, that's my experience.

Maybe you had edited the config.php after uploading, just a guess.

If that's not the case or doesn't help and you are desperate enough, then try posting your problem to the phpBB forums, they are a pretty helpful bunch of people too.
Wink
Helios
i think i've made some mistakes when i've moded the code..
i'll just try to do everything over again.


thank you for your help...
Related topics
Sql Error: 1017. Missing all the indexes files of phpbb
SQL error notification in my forum
SQL error on my site
PhpBB error on uploading avatar from url
[man] SQL Error : 1054 Unknown column \'session_admin\ en DB
SQL Error while installing PHPBB
Wiki??
SQL ERROR [ mysql4 ] - due to hosting? -
Strange SQL error
All new files Lost !
Move database to different SQL server
SQL ERROR [ mysqli ]
Php update?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.