SQL Error : 1146

dragostanii · Beginner Joined: Dec 23, 2006 Posts: 4

DEBUG MODE

SQL Error : 1146 Table 'usr_web28_1.GALLERY2_TABLE' doesn't exist

INSERT INTO GALLERY2_TABLE (fullPath, embedUri, g2Uri, activeAdminId, utf8_translate) VALUES ('http://www.boranii.de/progs/gallery2/embed.php', '/progs/phpbb2/gallery2.php', 'http://www.boranii.de/progs/gallery2/', 0, 1)

Line : 114
File : admin_gallery2.php

I have upload all files

i had made the table:

Code: › CREATE TABLE `phpbb_gallery2` (
`fullPath` VARCHAR( 255 ) NOT NULL ,
`embedUri` VARCHAR( 255 ) NOT NULL ,
`g2Uri` VARCHAR( 255 ) NOT NULL ,
`activeAdminId` INT NOT NULL ,
`utf8_translate` TINYINT( 1 ) NOT NULL,
`exportData` TEXT NULL
);

the DB usr_web28_1 is for phpbb2
the DB usr_web28_2 is for Gallery2

sry for the bad english but im a german..

AdBot

dari · Posted: Wed Jan 17, 2007 1:38 pm Post subject: Re: SQL Error : 1146

that's a problem w/ string replacement in the script. make sure that you made all the mods in the txt file.
_________________

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1139

Code: › #
#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

#
#-----[ AFTER, ADD ]------------------------------------------
#
define('GALLERY2_TABLE', $table_prefix.'gallery2');

GALLEY2_TABLE is a constant and should not show up in the actual query. Make sure the above mod was made correctly.

dragostanii · Beginner Joined: Dec 23, 2006 Posts: 4

I have it now 5 times tried to merge however it did not fold. It is always another error. I give it up, I try it now with phpnuke. A German language file for the integrations package (phpbb2) gives here: http://www.boranii.de/mods/g2_integrati ... _files.rar

or have anyone the files ready for me ???

sry for the bad English im onlya german Wink

GregKopp · Beginner Joined: Oct 04, 2007 Posts: 1

I had the same problem, but figured it out now.

But on to the next.. Does this mod only work with the subSilver theme?
How do I get it into another theme?