Msql database error

Hi,

I just uploaded my site from my localhost to a server but all i am getting is a database query error on home page and admin home page as well.

This is the error.

Database error in Underground Hang-Out Zone
Query:
SELECT `ID` FROM `LocalizationLanguages` WHERE `Name` = 'en-us'

Mysql error:
Table 'octopa.LocalizationLanguages' doesn't exist

Found error in file /home/octopa/public_html/inc/languages.inc.php
at line 100. Called db_value function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/octopa/public_html/inc/db.inc.php
[line] => 115
[function] => db_res
[args] => Array
(
[0] => SELECT `ID` FROM `LocalizationLanguages` WHERE `Name` = 'en-us'
[1] => 1
)

)

[2] => Array
(
[file] => /home/octopa/public_html/inc/db.inc.php
[line] => 133
[function] => db_arr
[args] => Array
(
[0] => SELECT `ID` FROM `LocalizationLanguages` WHERE `Name` = 'en-us'
[1] => 1
)

)

[3] => Array
(
[file] => /home/octopa/public_html/inc/languages.inc.php
[line] => 100
[function] => db_value
[args] => Array
(
[0] => SELECT `ID` FROM `LocalizationLanguages` WHERE `Name` = 'en-us'
)

)

[4] => Array
(
[file] => /home/octopa/public_html/inc/languages.inc.php
[line] => 72
[function] => checkLangExists
[args] => Array
(
[0] => en-us
)

)

[5] => Array
(
[file] => /home/octopa/public_html/inc/languages.inc.php
[line] => 46
[function] => tryToGetLang
[args] => Array
(
[0] => en-us,en;q=0.5
)

)

[6] => Array
(
[file] => /home/octopa/public_html/inc/languages.inc.php
[line] => 27
[function] => getCurrentLangName
[args] => Array
(
)

)

[7] => Array
(
[file] => /home/octopa/public_html/inc/membership_levels.inc.php
[line] => 24
[args] => Array
(
[0] => /home/octopa/public_html/inc/languages.inc.php
)

[function] => require_once
)

[8] => Array
(
[file] => /home/octopa/public_html/inc/modules.inc.php
[line] => 24
[args] => Array
(
[0] => /home/octopa/public_html/inc/membership_levels.inc.php
)

[function] => require_once
)

[9] => Array
(
[file] => /home/octopa/public_html/inc/admin.inc.php
[line] => 23
[args] => Array
(
[0] => /home/octopa/public_html/inc/modules.inc.php
)

[function] => require_once
)

[10] => Array
(
[file] => /home/octopa/public_html/inc/design.inc.php
[line] => 22
[args] => Array
(
[0] => /home/octopa/public_html/inc/admin.inc.php
)

[function] => require_once
)

[11] => Array
(
[file] => /home/octopa/public_html/inc/profiles.inc.php
[line] => 22
[args] => Array
(
[0] => /home/octopa/public_html/inc/design.inc.php
)

[function] => require_once
)

[12] => Array
(
[file] => /home/octopa/public_html/admin/index.php
[line] => 26
[args] => Array
(
[0] => /home/octopa/public_html/inc/profiles.inc.php
)

[function] => require_once
)

)


Called script: /admin/index.php

Request parameters:
Array
(
[gk_temp_width] => 900
)


--
Auto-report system

By the way on my localhost the database was using a different name and i changed it upon uploading the files. I think I have made all changes that refer to it correctly...that is in the inc/header and ray/modules/global/header.inc.php

Please help!

http://www.boonex.com/trac/dolphin/wiki/GenDolFAQs#Ineedtotransfermysitetoanotherfolderserver.WhatdoIneedtodo

Hi guys. Thank you for your help so far but I followed the outlined instructions and I am still not connecting correctly to my database. It is saying "Database query error." Click this link to find out: http://www.octopa.co.zw I would appreciate any help guys to get it up and running.

Have you tried just installing the default dolphin database on the server?...with your modified files.

Make a new database, name it, add user and all privs, import sql file which you find in the install dir.

Amend header.inc.php to reflect new database name.

Copy the admins tables from your old database in phpmyadmin and then paste them into sql query area in phpmyadmin. needed or you wont be able to log into admin area

After that load in the sql for all your mods + any updates....dont forget any mod that needs initialising by php.

then run

modCompileLanguage.php

modCompilePage.php

then log into admin and settings - language settings - compile language.

should work