FUDforum: FUDforum Installation Issues » Not using Temporary Tables

Home » FUDforum » FUDforum Installation Issues » Not using Temporary Tables

Show: Today's Messages :: Polls :: Message Navigator

Re: Not using Temporary Tables [message #40231 is a reply to message #40229]

Sat, 26 January 2008 03:51

BAD35th

Messages: 61
Registered: February 2007
Location: Hammertown

Karma:

Member

Just for fun I tried using the install.php from V2.7.7

This time I get a different error:

FATAL ERROR: your MySQL account does not have permissions to run LOCK queries on existing MySQL tables
Enable this functionality and restart the script.

I had the hosting place open a ticket for me to add the LOCK priviledge to the DB account so hopefully that does it.

Since they 100% do not support temporary tables will this be a problem for when FUD is up and running in normal use??

Back to original task: so to Move Servers I am assuming I will have to upgrade the existing forum version from 2.6.10RC3 to 2.7.7 and then backup and restore to new host running identical version. EDIT: Ran the upgrade to 2.7.7 and it worked fine!

Also there will still be some differences at new hosting, the php is changed from V4 to V5. The MySQL is also changed from V4 to V5, and finally the paths will be different for Server Root and Forum Data Root...will any of this matter ??

Thanks...

[Updated on: Sat, 26 January 2008 08:14]

Report message to a moderator

[Message index]

		Not using Temporary Tables By: naudefj on Wed, 05 October 2005 03:31
		Re: Not using Temporary Tables By: Ilia on Wed, 05 October 2005 13:31
		Re: Not using Temporary Tables By: naudefj on Wed, 05 October 2005 15:13
		Re: Not using Temporary Tables By: BAD35th on Thu, 24 January 2008 04:38
		Re: Not using Temporary Tables By: Ilia on Fri, 25 January 2008 00:34
		Re: Not using Temporary Tables By: BAD35th on Fri, 25 January 2008 23:01
		Re: Not using Temporary Tables By: BAD35th on Sat, 26 January 2008 00:48
		Re: Not using Temporary Tables By: BAD35th on Sat, 26 January 2008 03:51
		Re: Not using Temporary Tables By: Ilia on Sun, 27 January 2008 16:41

Previous Topic:	v 2.7.7 Step 2: CREATE UNIQUE INDEX
Next Topic:	FUD on Slackware 12

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 03:01:02 GMT 2024

Total time taken to generate the page: 0.04973 seconds