mysql error (new for me)

dyingdemon · Beginner Joined: Aug 01, 2009 Posts: 2

ok iv done alot of mods before but this one is the fist for me with this wierd a mix up @_@ i have no clue how to fix this so i need some help >.<

Code: › General Error
SQL ERROR [ mysql4 ]

Table 'holyforc_phpb3.GALLERY2_DATA_TABLE' doesn't exist [1146]

SQL

UPDATE GALLERY2_DATA_TABLE SET g2i_dataValue = 'g2i_2-1249171354' WHERE g2i_dataName = 'g2i_acpAdmin'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_gallery2.php
LINE: 1649
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_gallery2.php
LINE: 380
CALL: acp_gallery2->_set_ACP_admin()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_gallery2->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

AdBot

IngerK · Posted: Sun Aug 02, 2009 2:33 am Post subject: Re: mysql error (new for me)

Did you create the table? (SQL section in install.xml)

dyingdemon · Beginner Joined: Aug 01, 2009 Posts: 2

OMG dude im so srry for wasting your time @_@
i did make the table
... i put it in the wrong DB
xD
i put it in my Galaxytool db ahahahahaha
thx (i might be back though)

*update*
after trying i see that this is the SQL query that install gives

Code: › CREATE TABLE phpbb_gallery2_data (
g2i_dataName varchar(255) NULL, g2i_dataValue TEXT NULL
) CHARACTER SET 'utf8' COLLATE 'utf8_bin';

and it creates the table as seen here

[imageshack.us]

but i still get the same error
i wonder? is the auto configure setting for the gallery 2 (gallery 2 has been done but the auto gonfigure is the problem) trying to locate phpbb_gallery2_data_table
instead of phpbb_gallery2_data

and would droping the table and making a new one help in any way?

IngerK · Posted: Sun Aug 02, 2009 8:27 am Post subject: Re: mysql error (new for me)

Please post the last error message. From the first:

Quote: ›
Table 'holyforc_phpb3.GALLERY2_DATA_TABLE' doesn't exist [1146]

Is "holyforc_phpb3" or "phpbb" (printscreen from mysqladmin) your table prefix?

Tenshikun · Beginner Joined: Oct 28, 2009 Posts: 1

I am having the same issue, used autoMOD to install, had no errors. I get this error when trying to sync users.

Code: › SQL ERROR [ mysqli ]

Table 'g2test.GALLERY2_DATA_TABLE' doesn't exist [1146]

SQL

UPDATE GALLERY2_DATA_TABLE SET g2i_dataValue = 'g2i_2-1256747294' WHERE g2i_dataName = 'g2i_acpAdmin'

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_gallery2.php
LINE: 1649
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_gallery2.php
LINE: 752
CALL: acp_gallery2->_set_ACP_admin()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_gallery2->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

PoPoutdoor · Wizard Joined: Jan 20, 2006 Posts: 129

Don't use autoMOD, I'm sure this doesn't work well!

Web Hosting India