Table prefix doesn't work

[Klaas]

Cause I allready have a messages-table in my DB, this is one major conflict.

I filled in the prefix, but after checking the DB, no table HAS the prefix...

Sollutions anyone?

[Klaas]

I'm sorry for my impatience, but I need this thing going. I assume (and checked) the prefix from the install.php alters the tablenames, BUT IT DOESN'T.

Can I manually alter the names, and if so, what are the attributes for the Messages-table?

[PHPlugin]

im not a specialist, but whats your prefix?

so you set the prefix, but in the db no table had the prefix?

[edwin]

Just leave the prefix empty (if you don't want more than 1 YaBBSE in your db)

[Klaas]

No prefix is not an option, since I allready have a table with the name Messages...

[Klaas]

I scrolled through the different messages on this board. More people have problems with the prefix. My conclusion: It just isn't working... just... aaargh... just call me when it's fixed... until then... have fun...  

[Joseph Fung]

It's worked fine in all the tests I've run.

If you want to do it the hard way - you can download the safemode installer and modify .sql file to change all the table name.

[Jay Silverman]

It's worked fine in all the tests I've run.

If you want to do it the hard way - you can download the safemode installer and modify .sql file to change all the table name.

One of the installations I did today, the prefixes didn't work.  Others worked fine.

[Joseph Fung]

It's worked fine in all the tests I've run.

If you want to do it the hard way - you can download the safemode installer and modify .sql file to change all the table name.

One of the installations I did today, the prefixes didn't work.  Others worked fine.

That's really, really odd - as the installer simply taks the prefix, does a file() on the sql file, and replaces all the table names with $dbprefix.tablename before running the insert ..... I guess it might not do anything if track-globals is off - but then the entire installer should crap out.   That's relaly funky

[Darren Nye]

Hi Joseph - and others...

I tried installing yabbse last night, and had the same problem error as mentioned in:

http://www.yabb.info/community/index.php?board=131;action=display;threadid=2952

The error was "Table 'xxx.yabbse_members' doesn't exist" (substituting xxx for my account name)

I logged into mySQL command line and ran a "show tables;" - and all tables listed, but without the default prefix of yabbse_ in front of each table name (I think that's what was supposed to happen?). I did not change that option during the install, so each table should have had that prefix.

Since they didn't, I took the suggestion in the thread mentioned above, and edited settings.php, and set $db_prefix to an empty string "".

When I tried going back to create the administrator account, it worked.

I have not tried to do anything else with yabbse yet - as I installed this in a directory that isn't yet mapped to the correct domain name. So I already noticed that when running the board, all the images are missing (cause the URL in settings.php is looking at the actual domain name, which doesn't have the folders I specified).

Anyway, if I have more trouble within the next few days, I'll post another message.

Joseph,

It looks like this is a common problem. If you need me to step through anything to help diagnose the problem, shoot me an email. I'm not working right now so I have some time on my hands. Could even give you my voice number if you want it.

Catch you later.

[Joseph Fung]

Sorry - I forgot to post here.  We found the problem and it has been fixed - and will be released with the maintenance package.

it's because versions of php < 4.0.5 don't like the str_replace function we used