Database Error: GIParams

Need some help on this one...V6.1.4, VPS

-

Here is the email error that I am getting:

-

Database error in Big Bear Valley Voice -- Your Community, Your Voice
Query:
SELECT `VALUE` FROM `GlParams` WHERE `Name` = 'lang_default'

Mysql error:
Table 'lrepton2_bvv.GlParams' doesn't exist

Found error in file /home/lrepton2/public_html/community/inc/db.inc.php
at line 174. Called db_assoc_arr function with erroneous argument #0

-

Here is the function in db.inc.php

-

function getParam( $param_name, $use_cache = true )
{
global $cacheParam;

if ( $use_cache && isset($cacheParam[$param_name]) )
return $cacheParam[$param_name];
elseif ( !$line = db_assoc_arr( "SELECT `VALUE` FROM `GlParams` WHERE `Name` = '$param_name'" ) )
return false;
$cacheParam[$param_name] = $line['VALUE'];
return $line['VALUE'];
}

-

Need help to know what to fix?

-

Thanks.

-

L

When I go to phpMyAdmin it shows NO TABLES in the database.

I have restored previous dumps from within admin and still no tables are visible in phpMYadmin (Site is working tho...I am perplexed!).

Can someone please take a look at the error I am getting here?

-

That way I know where to look or what to tell the host...

-

Thanks.

-

~~ L

You now have CPanel on your VPS server? I would do all your backups and restores via CPanel in the future. I have restored my database a number of times this way and it has always worked. I don't know if this is an option for you right now, hopefully so.

Stuart

 I'm not going to say this IS the cause but it sounds like to me that

Mysql error:
Table 'lrepton2_bvv.GlParams' doesn't exist

might be because of case sensitivity I would check to see if the actual table looks like "glparams" or "GLParams"

As for the other issue of not seeing the tables in the database, this might be a file permission problem aswell , this is just a thought.

2 lrepton

1. If you haven`t any tables in database .. even admin will stop working :)  mystic

2. Ok .. if all ok .. Database Restore stage .. if your dump will weight in many megabytes (100 as example)

you will have trouble with importing (usually for huge databases used SSH method for importing directly to SQL)

3. and last .. recheck database which you checked and which used your dolphin (is it same ? ) .. look into header.inc.php to view which database used dolphin

PS. Yes, exporting to zip (smaller) via phpMyAdmin is better way (or even SSH export)

Hi Stuart,

-

I have five sites to move from shared server HSphere to VPS with CPanel. The first move with all the Server issues (the 100+ post) is operating fine...no database probs.

-

This is the second site being moved and it appeared to move fine until I started getting this errors. And when I checked the database for it in CPanel there are no tables there. (On first site moved, tables ARE there...I performed the procedure the same way.)

-

I've had some rest now...so I am going to review each step for second site.

-

~~L

-

Today, can't even access the site....DATABASE error is prominent.

-

Here is what it is kicking out today.

-

Database error in Big Bear Valley Voice -- Your Community, Your Voice
Query:
SELECT `ID` FROM `LocalizationLanguages` WHERE `Name` = 'en-us'

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

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

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/lrepton2/public_html/community/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/lrepton2/public_html/community/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/lrepton2/public_html/community/inc/languages.inc.php
[line] => 98
[function] => db_value
[args] => Array
(
[0] => SELECT `ID` FROM `LocalizationLanguages` WHERE `Name` = 'en-us'
)

)

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

)

[5] => Array
(
[file] => /home/lrepton2/public_html/community/inc/languages.inc.php
[line] => 46
[function] => tryToGetLang
[args] => Array
(
[0] => en-us
)

)

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

)

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

[function] => require_once
)

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

[function] => require_once
)

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

[function] => require_once
)

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

[function] => require_once
)

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

[function] => require_once
)

[12] => Array
(
[file] => /home/lrepton2/public_html/community/cc_forum_spy.php
[line] => 10
[args] => Array
(
[0] => /home/lrepton2/public_html/community/inc/profiles.inc.php
)

[function] => require_once
)

)


Called script: /community/cc_forum_spy.php

Request parameters:
Array
(
[show] => 5
[length] => 50
[mlength] => 165
[rnd] => function random() {    [native code]}
[__utma] => 169191858.2042601801958453500.1222213904.1222213904.1222213904.1
[__utmc] => 169191858
[__utmz] => 169191858.1222213904.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
)


--
Auto-report system

Lorren,

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

Yes..I see that. None of the tables exist,  even after upload of dump.

-

Have user to db ALL PRIVILEGES!!

Yup, they have ALL.

-

Do I understand this correctly - that yesterday the site worked. but today you can't access it at all - with no changes on your part?  If the tables aren't there they must have deleted somehow - either a hacker of a restore that misfired?

-

Rob

Going to start all over with the migration for this site...

-

~L

Yes...it APPEARED to work (could've been cached). I don't think it was hacked....but I will know more once I finish the upload for the migration.

-

What a headache...ugh.

-

The other site that I migrated first...is running with no problems at the moment...new members signing up, etc.

-

Error, bloody error...argh!

-

Database error in Big Bear Valley Voice -- Your Community, Your Voice
Query:
SELECT `ID` FROM `LocalizationLanguages` WHERE `Name` = 'en-us'

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

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

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/lrepton2/public_html/community/inc/db.inc.php
[line] => 115
[function] => db_res
[args] => Array
(

This happens after migrating the site AGAIN.....BRAND SPANKING NEW DATABASE CREATED.

-

I was able to upload a dump from old site (that I am migrating) into a complete new install for this domain...so there is not anything wrong with database dump.

-

What is happening here?

-

~~L

-

As you can see...one database (new install) is full of records, while the others are not.-

LocalizationLanguages?

I don't want to speak too soon...but I think that with the fresh install and the database from the old site. We appear to be in business.

-

I've copied over with my templates, images....all I need to be able to do now is copy the language file over. I made many changes the the language file and if I can help it, I don't want to have to go in and add each one back.

-

Any ideas?

-

Thanks

-

~~ L

-

PS There must have been some file corrupted in the migration(upload and download of files) that was replicated twice.

Lorren.

Why are you saying that the 'dump' was successful when the image shows the 'voice' database  with 0 (ZERO) tables which is the source of your error? (no tables, does not exist)

Mysql error:

Table 'lrepton2_voice.LocalizationLanguages' doesn't exist

Hi Rumpy,

-

The database bvv was the database used in the first attempt at migration of the site. No database tables visible after migration and getting error.

-

The database bbvtest was used for a fresh install (then added the dump from old server to see if the database was causing the problem, no it isn't. That database dump loads perfectly. 162 records)

-

For the final attempt at migration, I created a NEW database VOICE. The migration failed again...no records are visible.

-

The databases appear in the backup folder....so I do not understand why they are not there in phpmyadmin and therefore causing  the error.

-

~~L

If you still have access to the old database just export to file with phpMyAdmin and then import it in the new one  .....

The database doesn't appear to be the problem...I think some of the other Dolphin files have been corrupted with the upload/download from old server to new.

-

Database worked in NEW install.

-

~L

-