Thread: Upgrade Database from older versions to v4

AeWebWorks has released a script for the upgrade... I have not tested it yet - but I am sure to shortly, as I have some of this work on my table.

The info is attached here...

If you try it, give some feedback, so we can address any/all issues...

One person on the aeWebWorks public forum reported it has some trouble, but this has not been confirmed.

If it does have trouble, I will try to combine my code, with theirs, to have a working solution. Lets see how the code from them works first, though.

Smoge

Smoge,

I get this error message when I run the SQL file you attached above

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1
STR: //
SQL: // banners:

ALTER TABLE `Banners` ADD `Position` INT( 4 ) DEFAULT '4' NOT NULL

SQL-query:

// banners: ALTER TABLE `Banners` ADD `Position` INT( 4 ) DEFAULT '4' NOT NULL

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '// banners:

ALTER TABLE `Banners` ADD `Position` INT( 4 ) DE

Hello,

I use aedating 3.3 and try to upgrade it to v4.0 with the new sql script but I get the same error.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '// banners:

ALTER TABLE `Banners` ADD `Position` INT( 4 ) DEF

Well - the

Code:

//

means comment, or at least, it was intended to mean comment.

So, you don't need to run this line...

I would run each batch of statments between the "//" sections individually, so you can easily see what works and what fails.

Usually, in mySQL, "--" is used to show a comment....

So, if you want to run it all at one shot, you should replace the // with --, or simply delete the comments totally.

Remember, these commands are supplied to you here as aeDating supplied them... I have not added or changed or tested any of it yet.

Smoge

PS: I hope everyone does backups before they try any of this stuff!

Thanks Smoge....I found out that the // could be replaced by # to be used as comment.

I ran the individual lines went ok until I tried....

UPDATE ProfilesDesc SET join_page = `order` +1000 WHERE `profile_type` = 'single' UPDATE ProfilesDesc SET join_page = `order` +2000 WHERE `profile_type` = 'couple'

then error message came up

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE ProfilesDesc SET join_page = `order`+2000 WHERE `profile

Any Suggesstion?

This is the correct code:

Code:

UPDATE ProfilesDesc SET join_page = `order` + 1000 WHERE `profile_type` = 'single';
UPDATE ProfilesDesc SET join_page = `order` + 2000 WHERE `profile_type` = 'couple';

Originally Posted by hacker

I ran the individual lines went ok until I tried....

Code:

UPDATE ProfilesDesc SET join_page = `order` +1000 WHERE `profile_type` = 'single' UPDATE ProfilesDesc SET join_page = `order` +2000 WHERE `profile_type` = 'couple'

then error message came up

Originally Posted by hacker

I ran the individual lines

I think by section is ok - individual lines is too time consuming.

Smoge

I needed to upgrade a v3.1 site... and this required some changes to the upgrade file.

I renamed the file to .txt, as it is not really for importing directly, and should not be a .sql

It now has some comments telling you to do some different things if you are running v3.1

The v3.1 database is working using the v4.01 files - but it has not been tested. I'm sure you will find some other tables or changes that need to be made.

If you do, please post them here.

Smoge

Here is a new version, version 3.

Smoge

Additional GlParam needed:

Code:

INSERT INTO `GlParams` VALUES ('friendlist', 'on', 15, 'Show Friend List', 'checkbox', '', '');

It is not in version 3 of the update file.

This will be added to version 4 of the update file when it is ready.

Smoge