Nukemods Forum  
» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 41
0 members and 41 guests
No Members online
Most users ever online was 611, 03-21-2008 at 11:10 PM.
» .::.
Online Degree - search for 1000+ online degrees, online colleges & online universities.
Tattoo - we are a group of tattoo enthusiasts
Gexa Energy - your absolute best choice in electric service
Texas electricity - save on electric rates
The Lyric Archive
Dining Room Furniture

Go Back   Nukemods Forum > PHP-Nuke 7.x > Nuke 7.x - General

Reply
 
LinkBack Thread Tools Display Modes
Upgrade Issues on MySQL
Old
  (#1 (permalink))
Junior Member
 
Status: Offline
Posts: 12
Join Date: Nov 2004
Upgrade Issues on MySQL - 06-19-2005, 08:53 PM

OK I am trying to upgrade my version of Nuke to v7.8 as I need to get Banners working with Flash/Javascript etc (if anyone knows any other way please tell me as well).
When I goto MySQL and either Copy and Paste the querys or just select the nuke.sql file I get page cannot be displayed. I have have my Host check the server and the issue is not at their end. I can also just add a single line Query and it works no problems its just the complete new nuke.sql that seems to be the issue.
What I am wondering is do I need to remove the old querys first before adding these new ones as most of them obviously have the same name.

Yeah I did use search so if I missed the answer sorry.
Edit: Currently using 7.4 if that makes a difference.
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Re: Upgrade Issues on MySQL
Old
  (#2 (permalink))
Member
 
Status: Offline
Posts: 450
Join Date: Jul 2004
Re: Upgrade Issues on MySQL - 06-20-2005, 07:22 AM

Quote:
Originally Posted by liliputt
page cannot be displayed.
That would be a slow or bad connection, or you have reached a limit ie: allowed to upload or copy&paste in the query box.

Your main problem is that some of the tables are the same, there should be a upgrade folder within your download, find that or find out what tables need to be upgraded. Then you will have to manualy sql these tables etc...

However heres a suggestion, download your exsisting database (structure & data) then download data only. This is for if anything goes wrong.

Now create a new database or just drop the old one completly.

Run the nuke.sql to create the new database & its tables, then run your (downloaded) data file into your new database. Thats it.......


What is Pay Per Play ?
ADVERTISING has commenced!!! We have launched!!!!!!!
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#3 (permalink))
Junior Member
 
Status: Offline
Posts: 12
Join Date: Nov 2004
06-22-2005, 06:52 AM

Thanks for the reply Marty.

Regarding the Bad connection with page cannot be displayed it only happens when I do the complete nuke.sql file. If I just do 1 query it works fine. On ADSL so cant think thats a problem with connection.
Also there is not just an upgrade sql file - the one it has contains all the querys that are already there.
I have downloaded the datebase so I guess I will give your 2nd option a go.

Cheers again.

Edit: Doh just realised those 7.4-7.5 upgrade files do what you mentioned hehehe.

Will try those - thanks again
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
SubBlack Issues hoosier79 Theme packs 7 05-16-2005 06:49 PM
PHP-Nuke issues Torojon Nuke 7.x - General 2 12-19-2004 01:47 AM
Avatar issues chatserv nukemods.com 4 03-19-2003 01:18 PM
Forum Issues TuNa Purged Topics 5 02-19-2003 05:04 PM




vBulletin Skin developed by: vBStyles.com


LinkBacks Enabled by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31