I formally had a php-NUKE site and after messing about managed to migrate the entire forum over to mybb 1.2.
Now i want to upgrade to 1.4 so i followed the instructions and copied over the 1.4 files, however upon trying to upgrade i get this error.....
Fatal error: [SQL] [1146] Table 'urbanmonkeys2.UMCmybb_UMCmybb_users' doesn't exist
UPDATE UMCmybb_UMCmybb_users SET `newpms`='0' WHERE uid='1' in /var/www/vhosts/urban-monkeys.co.uk/httpdocs/UMCmybb/inc/db_mysql.php on line 544
From what i see it looks like it has applied the database prefix twice (UMCmybb) but i lack the knowlege to fix it...
can anyone help ?
Update...
As I had no answer so far I deleted and started again this time i left the prefix as the default mybb_ but alas i STILL have the above problem..
Fatal error: [SQL] [1146] Table 'urbanmonkeys2.mybb_mybb_users' doesn't exist
UPDATE mybb_mybb_users SET `newpms`='0' WHERE uid='1' in /var/www/vhosts/urban-monkeys.co.uk/httpdocs/UMCmybb/inc/db_mysql.php on line 544
http://community.mybboard.net/thread-24122.html
according to this ..like you said ..as of MyBB 1.4
Quote: Remove TABLE_PREFIX. from $db->simple_select, $db->update_query, $db->insert_query, $db->delete_query, $db->table_exists, the second argument in $db->field_exists, $db->optimize_table, $db->analyze_table, $db->show_create_table, $db->show_fields_from, $db->is_fulltext, $db->supports_fulltext, $db->supports_fulltext_boolean, $db->create_fulltext_index, and $db->drop_index
which simply says that remove the TABLE_PREFIX. from you db queries in any custom php plugins or pages
(2008-08-26, 11:38 AM)BulletMag Wrote: [ -> ]Fatal error: [SQL] [1146] Table 'urbanmonkeys2.[i][b]mybb_[/b][/i]mybb_users' doesn't exist
UPDATE mybb_mybb_users SET `newpms`='0' WHERE uid='1' in /var/www/vhosts/urban-monkeys.co.uk/httpdocs/UMCmybb/inc/db_mysql.php on line 544
since u have not done that the double prefix appears
I physically deleted ALL plugins as soon as i installed 1.2 so i don't understand what's happening.
I started again and under 1.2 my merged forum works fine and all my existing admins are able to access the ADMIN-CP, however when i do the upgrade to 1.4 i get the corrupted theme but all the posts are there... and i get one of 2 errors when trying to access ADMIN-CP
Fatal error: Cannot redeclare is_super_admin() (previously declared in /var/www/vhosts/urban-monkeys.co.uk/httpdocs/UMCmybb/inc/functions.php:5021) in /var/www/vhosts/urban-monkeys.co.uk/httpdocs/UMCmybb/admin/adminfunctions.php on line 2383
or
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1146 - Table 'urbanmonkeys2.mybb_mybb_users' doesn't exist
Query:
UPDATE mybb_mybb_users SET `newpms`='0' WHERE uid='1'
Please contact the MyBB Group for support.
Im still getting the doubled up database prefix but i have no plugins installed at all (there are physically NONE in the plugins folder)
Im still none the wiser.
Is there any way to change the doubled prefix AFTER 1.4 is installed ?
Ok unfortunately nothing seems to have worked so far so i thought i would experiment a little...
I erase all the previous installations and databases of mybb, i then installed 1.2.14 and left it at default as it installed...
Once done i deleted the install folder as required...
I logged in to the new mybb and logged into the Admin-cp just to make sure it worked, it did
I then copied the entire content of the UPLOAD folder in the 1401 (with the exception of the /inc/settings.php file) to the same folder as my existing mybb.
I then started the upgrade...
during the upgrade just after it requests that the cache folder be chmodded to 777 i get this error...
Warning: Invalid argument supplied for foreach() in /var/www/vhosts/urban-monkeys.co.uk/httpdocs/UMCmybb/install/resources/upgrade12.php on line 1904
However it continues but i get no theme when I open the site....
BUT here come the surprising thing i STILL am unable to log in to admin and get the SAME error as above
Fatal error: Cannot redeclare is_super_admin() (previously declared in /var/www/vhosts/urban-monkeys.co.uk/httpdocs/UMCmybb/inc/functions.php:5021) in /var/www/vhosts/urban-monkeys.co.uk/httpdocs/UMCmybb/admin/adminfunctions.php on line 2383
Now this is a vanilla install... NOTHING was changed and i followed the install instructions to the letter (although i chmodded the folders to 777 rather than 666)
What the hell is going wrong and why ?????
I suggest you download the full MyBB 1.4.1 package, and reupload all the files to your server.
(2008-08-31, 08:43 PM)DennisTT Wrote: [ -> ]I suggest you download the full MyBB 1.4.1 package, and reupload all the files to your server.
I have done MANY MANY times with the same problem... however if I do a standard 1.4.1 install (NOT upgrade) it works but this means I cant use the merge scrip to bring over my old forum.
All I can think of is the upgrade script is messing up somehow.
(2008-09-01, 01:35 PM)BulletMag Wrote: [ -> ] (2008-08-31, 08:43 PM)DennisTT Wrote: [ -> ]I suggest you download the full MyBB 1.4.1 package, and reupload all the files to your server.
I have done MANY MANY times with the same problem... however if I do a standard 1.4.1 install (NOT upgrade) it works but this means I cant use the merge scrip to bring over my old forum.
All I can think of is the upgrade script is messing up somehow.
Can you download the admin/adminfunctions.php from your forum and upload it here?
(2008-08-31, 10:03 PM)cybermidget Wrote: [ -> ]I have the same problem as BulletMag. I have EXACTLY ZERO PLUGINS (unless translations count) and I'm getting the double prefix error WHEN RUNNING THE UPGRADE SCRIPT!
I'm upgrading from 1.2.14 to 1.4.1
http://kardinal-airsoft.110mb.com/forum/
Fatal error: [SQL] [1146] Table 'kardinal-airsoft_kaqf.mybb_mybb_users' doesn't exist
UPDATE mybb_mybb_users SET `newpms`='0' WHERE uid='1' in /www/110mb.com/k/a/r/d/i/n/a/l/kardinal-airsoft/htdocs/forum/inc/db_mysql.php on line 544
All I did was upload the new MyBB with FTP, I had no plugins when I started! What am I supposed to do? I looked at the config.php files and I've gone through the Database...
What table prefix are you using in your inc/config.php?
Ok here's what prefix I use...
$config['database']['table_prefix'] = 'mybb_';
and attached is my admin/adminfunctions.php file
*edit* could it be something to do with the patch that was recently added to 1.4 (making it 1.4.1)
I cant find 1.4 to try
Here we go again...
I AGAIN erased EVERYTHING and started again from scratch...
This time in installed 2 folders, one containing mybb 1.2.14 the other 1.4.1
I installed each one seperately using the database prefix mybb12_ and mybb14_ respectively
BOTH forums work fine and I'm able to access EVERYTHING with NO ERRORS !!
This leads me to the conclusion that there MUST be something wrong in the update script.
I'm trying to fix this myself as it seems I'm not the only person having the same trouble, was just hoping to get a little more insight.... oh well ill post if i find a solution.