eSyndiCat Pro v1.2 - v2.0 MySQL upgrade instructions [Archive]

Simon Gooffin

11-08-2006, 05:04 AM

Hi All,
I have just put our upgrade file to downloads area. You can find it here:
http://www.esyndicat.com/downloads/modifications.html

Here are the detailed instructions how to upgrade your 2.0 version.

1. MAKE BACKUP OF YOUR VERSION (files, database)
2. Download the upgrade script
3. Unpack it. You will see one folder and upgrade.php file.
4. Upload unpacked folder and file to your esyndicat 1.2 version directory
5. Go to admin panel -> manage database -> import
6. Choose pre_upgrade from dropdown list. Click go. You should get successful notification in case everything is ok.
7. Now run upgrade.php via your browser. Example: you have your directory installed here:
mydomain.com/esyndicat/
so you should open the following url in your browser:
mydomain.com/esyndicat/upgrade.php
In case everything is ok you will get successful notification
8. Now let's get back to our manage database in admin panel. Click import and now choose post_upgrade from dropdown list.
9. Remove upgrade.php and updates/pre_upgrade.sql, updates/post_upgrade.sql
10. Upload all files & directories from 2.0 version except includes/config.inc.php and install/ directory

That's all. Please inform in case you have problems.

Additional note due to increased number of upgrade requests:
You can order professional upgrade from our team. It costs as low as $37. It will be completed within 48 hours. We do not upgrade your custom skin. We will upgrade only NON CUSTOMIZED versions. If you want your custom skin to be upgraded as well that will be quoted separately.
What actions you should take to order upgrade:
1. Email your transaction ID, forums username, real name and email where we can send a payment link. Please use sales@esyndicat.com email for this
2. After payment is received we need your ftp details, phpMyAdmin credentials for upgrade

We start upgrading after payment confirmation

tsands

11-08-2006, 07:48 AM

great work Simon! upgrade worked perfectly and the instructions were on point. my site is so much faster now. the new db structure is much better. :cool-yo:

Simon Gooffin

11-08-2006, 09:08 AM

Cool, I'm really glad you have done this yourself :) I tried to make upgrade as easy as possible

fabian1

11-08-2006, 10:33 AM

great !!! it works well now.

snerd

11-08-2006, 10:50 AM

mk10

11-08-2006, 10:56 AM

I've a problem.
I upgraded. First it worked all. then i tried the new templates. and now the categories in the frontend aren't shown any more, just popular links and new links. in the backend i see the categories. in the frontend there's only root shown? what's the reason?

http://www.recording-verzeichnis.de

subseo

11-08-2006, 11:05 AM

I have one directory that's running 1.1 - thus I guess I need to first upgrade to 1.2, and only after that to 2.0, right? The answer is probably obvious, but thought to ask anyway, just in case. Thanks.

Michael Hill

11-08-2006, 11:09 AM

I've a problem.
I upgraded. First it worked all. then i tried the new templates. and now the categories in the frontend aren't shown any more, just popular links and new links. instead there's only root shown? what's the reason?

http://www.recording-verzeichnis.de

Just change 'id' value for ROOT from '1' to '0'.

mk10

11-08-2006, 11:13 AM

Just change 'id' value for ROOT from '1' to '0'.

where can i do that?

Michael Hill

11-08-2006, 11:20 AM

UPDATE `YourPrefix_categories` SET `id` = '0' WHERE `title` = 'ROOT'

YourPrefix - your table prefix. Set this query in AdminPanel->ManageDatabase

mk10

11-08-2006, 11:29 AM

thanks that worked, but now i have still the problem that the pages i manually added aren't any longer there. is this a problem with the language.

globalone

11-08-2006, 11:34 AM

Hi Simon,

I am actually processing with the upgrade following your instructions.

Everything is ok till point 6) Choose pre_upgrade from dropdown list. I get the following message :

Table 'dir_banner_clicks' already exists

What should I do know ? :huh:

If I continue your instructions without taking care of previous bug and I run upgrade.php as explained I get the following message:

Unknown column 'min_rating' in 'field list'

For your information I customized the previous version 1.2. see it here

www.fr-cuisine.com

What sould I do know ? Please help :forgive:

Thanks in advance and kind regards.:air-kiss:
Nathalie

Simon Gooffin

11-08-2006, 03:30 PM

I was just looking through this upgrade script, and was wanting to make sure that it will pick up "links waiting for approval". I have hundreds of them to look over for inclusion. This upgrade script will keep them intact?

Mike
Hi Mike,
Yes, all the data will still exist as is. No changes in data at all. There will be changes in database only.

Mats Houbaer

11-08-2006, 06:14 PM

10. Upload all files & directories from 2.0 version except includes/config.inc.php and install/ directory do you mean the sql file?
with install/directory with directory you mean the sql file?
Regards/
Mats

Mats Houbaer

11-08-2006, 07:06 PM

Nothing much I fixed it myself...:smoke:

Shannon Hutcheson

11-08-2006, 07:18 PM

Running the upgrade worked out ok, no errors... However my directory also says there are no links on the index. There are hundreds..

My custom pages, manage plans text and custom fields seem to have disappeared totally. I'm very unhappy about this.

UPDATE `YourPrefix_categories` SET `id` = '0' WHERE `title` = 'ROOT'

YourPrefix - your table prefix. Set this query in AdminPanel->ManageDatabase

This resulted in the following error for me :( :sos:

Query Failed:
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 '\'0\' WHERE `title` = \'ROOT\'' at line 1

The news feature seems to not be working for me. All of this applies no matter what template I use. *sigh*

Featured and sponsored listing no longer work.

This is an immediate problem for me folks. ANY help would be appreciated. My site is useless as-is.

mk10

11-08-2006, 07:44 PM

My custom pages, ... seem to have disappeared totally. I'm very unhappy about this.

For me the same.

Nellie

11-08-2006, 08:27 PM

Hi Guys, I have upgraded, the admin looks great, but when I browse to my home page, it loads without the links and in there place is a Requested URL not found (404) error. I ran the SQL query to change 'id' value for ROOT from '1' to '0' and got this error:

Query Failed:
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 '\'0\' WHERE `title` = \'ROOT\'' at line 1

Where to now?

Shannon Hutcheson

11-08-2006, 08:44 PM

I think Simon et al are in a time zone which would make them usually asleep at this time of day (3:30 pm EST). So while I am patient because of this, I sure hope someone comes along with a solution soon.

Edit: my directory links numbers are now correct. I resolved that issue by using phpmyadmin.

My custom pages in the database ARE gone. I cannot browse them in dir_pages via phpmyadmin.

I have my saved database prior to upgrading. But I do not know how to restore the custom pages.

I believe my other issues are custom template based. However, using the default 2.0 or other 2.0 templates does not resolve those issues (featured, sponsored links, news etc)

mike odonnell

11-08-2006, 08:46 PM

i have upgraded from 1.2 to 2 and now in my suggest a category drop down box it doesntshow any of the sub categories only the main ones..
And i cant figure out how to get my news page to work..

mariancon

11-08-2006, 09:15 PM

Table 'dir_banner_clicks' already exists

Same error here

tsands

11-08-2006, 09:24 PM

i had the disappearing link and categories problem too. i used phpmyadmin instead of the admin of esyndicat to fix the issue.

Nellie

11-09-2006, 07:21 AM

Morning, I've had a good nights rest, tried it all again and still no joy - think I should stick ti crossword puzzles!

fabian1

11-09-2006, 08:23 AM

category droptlist display only the main category too.
and where is the crossed bouton for links ? because i can't assign links to 2 or 3 categories at the moment.

gismoben

11-09-2006, 06:17 PM

Table 'dir_banner_clicks' already exists

i get the same error too :(

Shannon Hutcheson

11-09-2006, 06:58 PM

*tap tap* It's been 24 hours now, with no reply from staff.

Is anyone looking into these issues? I'd rather not have to pay for support after already attempting to do the update and attend to my issues on my own. At this point I don't even know if the update caused my issues or if they are truly custom template related only.

edit: I'd love to know how to add the 'report this link' feature as seen on the current 2.0 demo site here.

The move listing feature *does not work* (no link to click on the pop up window) when you click the text link in the category view. However, it does work if you click the move link icon (folder) on the top right area.

Nellie

11-09-2006, 09:25 PM

I dont have any custom templates and have exactly the same errors :-(

John Turner

11-10-2006, 09:13 AM

Hi
1. Solution for How to change ID for ROOT category

Create file go.sql with substance

UPDATE `{prefix}categories` SET `id` = '0' WHERE `title` = 'ROOT';

Save and upload it to '../updates' on your site

Then it would be available
from Admin Panel » Manage Database » Import
choose it from dropdown and click 'GO'

2. Adding option to create cross-links

Please read this thread
http://www.esyndicat.com/forum/showthread.php?t=7505

Nellie

11-10-2006, 09:40 AM

Hi John, when I run the go.sql, I get this error:

Error: Table 'allintrosza.categories' doesn't exist
UPDATE `categories` SET `id` = '0' WHERE `title` = 'ROOT';

What should I do?

Simon Gooffin

11-10-2006, 10:03 AM

I'm sorry for the late reply.
1. Send me your dump of pages table and I will restore it for you,

I have my saved database prior to upgrading. But I do not know how to restore the custom pages.

Table 'dir_banner_clicks' already exists
It seems you have implemented this mod:
http://www.esyndicat.com/forum/showthread.php?t=5784&highlight=banner+clicks

The upgrade will not work with this mod implemented.

P.S. it is very difficult to track the problem here. Submit ticket to our helpdesk (http://www.esyndicat.com/support/desk/).

faisal1

11-10-2006, 11:21 AM

Hi

I have upgraded to v2 but i got this error messge when i visit the index..here is the error:

Error: Can't create/write to file '/tmp/#sql_4c50_0.MYD' (Errcode: 17)
(SELECT t1.*, COUNT(DISTINCTROW t4.`id`) num_links, '0' `crossed`, t21.`num_cols` FROM `dir_categories` t1 LEFT JOIN `dir_flat_structure` t2 ON t1.`id` = t2.`id_parent` LEFT JOIN `dir_link_categories` t3 ON t2.`id_category` = t3.`id_category` LEFT JOIN `dir_links` t4 ON t3.`id_link` = t4.`id` AND t4.`status` = 'active' LEFT JOIN `dir_categories` t21 ON t1.`id_parent` = t21.`id` WHERE t1.`id_parent` = '0' AND t1.`id` >= 0 AND t1.`status` = 'active' GROUP BY t1.`id` ORDER BY t1.`order` LIMIT 0, 10000) UNION ALL (SELECT t1.*, COUNT(DISTINCTROW t5.`id`) num_links, '1' `crossed`, t21.`num_cols` FROM `dir_categories` t1 RIGHT JOIN `dir_crossed` t2 ON t1.`id` = t2.`id_crossed` LEFT JOIN `dir_flat_structure` t3 ON t1.`id` = t3.`id_parent` LEFT JOIN `dir_link_categories` t4 ON t3.`id_category` = t4.`id_category` LEFT JOIN `dir_links` t5 ON t4.`id_link` = t5.`id` AND t5.`status` = 'active' LEFT JOIN `dir_categories` t21 ON t1.`id_parent` = t21.`id` WHERE t2.`id_category` = '0' AND t1.`status` = 'active' GROUP BY t2.`id` ORDER BY t1.`title` LIMIT 0, 10000)

mike odonnell

11-10-2006, 01:18 PM

i have upgraded from 1.2 to 2 and now in my suggest a category drop down box it doesnt show any of the sub categories only the main ones..
And i cant figure out how to get my news page to work..
Any fix for the drop down categories?

mariancon

11-10-2006, 03:55 PM

It seems you have implemented this mod:
http://www.esyndicat.com/forum/showthread.php?t=5784&highlight=banner+clicks

The upgrade will not work with this mod implemented.

I haven't implemented this mod and that's not related to banner table.

This is the only MOD I use: http://www.esyndicat.com/forum/post40090-9.html for reasons explained in that thread.

I already lost enough time with this system's basic functionality and I interestedly expect V 2.0. If for making it work correctly I have to pay an additional fee, I might consider another system.

redeye

11-10-2006, 04:36 PM

Using the "Upgrade" script will work if there are no errors found when the "pre_upgrade" script runs.

Unfortunately if an error is found, #1. it is reported and you are sent to an error page, which means you have run a second time, #2. the script still runs to completion.

This is how I got the script to work - it may be slightly different on your directory.

Backup everything before you do anything else

If you are given an error message you will need to fix it first before going any further (I had an ID error which needed fixing with myphpAdmin).
Even after fixing your error you will then get error messages saying Table 'dir_banner_clicks' already exists'
or similar, as the script has created the tables on the first run.

So fix your first error, and then go to myphpadmin and drop the tables created by the script when it first ran.

banner_categories
banner_clicks
language
mail_queue
messages

You will also probably need to drop the field 'recursive' from the "banners" table.
Once all that has been done the pre_upgrade should work and then just follow the original instructions from Simon in the first post.

dhowler

11-11-2006, 07:37 AM

I also had to delete from the banners table: showed, clicked, width, height, type, content, position, and target.

Unfortunately, I then get more errors, and the more I dump, the more I have to re-add to make the script work again.

I haven't really done anything but cosmetic mods, so I don't understand what's going on. I even had to change the sql files to change the prefix to dir_ in order for it to even get this far. *sighs*

http://recs.citadelofthewolf.com/

Nothing seems to be going my way lately.

Dreamy

Nellie

11-11-2006, 11:35 AM

Hi John, when I run the go.sql, I get this error:

Error: Table 'allintrosza.categories' doesn't exist
UPDATE `categories` SET `id` = '0' WHERE `title` = 'ROOT';

What should I do?

Any body got any suggestions? I'm new to php:-(

faisal1

11-11-2006, 06:08 PM

no answer :(

Nellie

11-13-2006, 10:59 AM

What about a bit of support guys, we understand that you are busy, but a little guidance wont take you long.

Shannon Hutcheson

11-13-2006, 12:36 PM

Still waiting on helpdesk support for my custom pages issue.

martinm

11-13-2006, 06:18 PM

Well...I try the pre_upgrade but I'm told that there's a duplicate

Duplicate entry '1' for key 1

I try it again and I get
Table 'dir_banner_clicks' already exists
But there wasn't before I started (even redid the mysql backup - the table isn't there...but it is after I run the pre_upgrade ). dir_banners_categories is also added. I remove them (they're both empty). I then run pre_upgrade and it says that I have:

Table 'dir_language' already exists

Again, it doesn't exist in my backup.

I gave up then.

Any thoughts, support?

lonrot

11-14-2006, 08:20 AM

Edited:
I mistakenly reuploaded the same 1.2 version, what a jerk.
Is working alright now, thank you guys.

Shannon Hutcheson

11-14-2006, 02:12 PM

Getting very frustrated and quite angry at this point. Where's the fantastic support there used to be? I submitted a help desk ticket 4 days ago. Nothing is being done whatsoever.

Rick Gardner

11-15-2006, 01:57 AM

I installed this script myself so one would assume that they would be able to complete a upgrade as well. The installation I had was getting very slow as the number of links continued to grow. I was hoping the upgrade would speed things up instead it has come to a halt. Note: There were no errors during the installation.

This is all I get when viewing the directory.

Error: Unknown column 't21.num_cols' in 'field list'
(SELECT t1.*, COUNT(DISTINCTROW t4.`id`) num_links, '0' `crossed`, t21.`num_cols` FROM `dir_categories` t1 LEFT JOIN `dir_flat_structure` t2 ON t1.`id` = t2.`id_parent` LEFT JOIN `dir_link_categories` t3 ON t2.`id_category` = t3.`id_category` LEFT JOIN `dir_links` t4 ON t3.`id_link` = t4.`id` AND t4.`status` = 'active' LEFT JOIN `dir_categories` t21 ON t1.`id_parent` = t21.`id` WHERE t1.`id_parent` = '0' AND t1.`id` >= 0 AND t1.`status` = 'active' GROUP BY t1.`id` ORDER BY t1.`` LIMIT 0, 10000) UNION ALL (SELECT t1.*, COUNT(DISTINCTROW t5.`id`) num_links, '1' `crossed`, t21.`num_cols` FROM `dir_categories` t1 RIGHT JOIN `dir_crossed` t2 ON t1.`id` = t2.`id_crossed` LEFT JOIN `dir_flat_structure` t3 ON t1.`id` = t3.`id_parent` LEFT JOIN `dir_link_categories` t4 ON t3.`id_category` = t4.`id_category` LEFT JOIN `dir_links` t5 ON t4.`id_link` = t5.`id` AND t5.`status` = 'active' LEFT JOIN `dir_categories` t21 ON t1.`id_parent` = t21.`id` WHERE t2.`id_category` = '0' AND t1.`status` = 'active' GROUP BY t2.`id` ORDER BY t1.`title` LIMIT 0, 10000)

John Turner

11-15-2006, 06:27 AM

Rick Gardner:
Please provide me with your CPanel and FTP credentials

Shannon Hutcheson:
Your pages are converted to v2.0 format.
It necessary your FTP and AdminPanel credentials.

Shannon Hutcheson

11-17-2006, 02:22 AM

I've sent several emails John and have not heard back from you.

John Turner

11-17-2006, 04:25 AM

Hi Shannon Hutcheson,

Your pages now ready.

Shannon Hutcheson

11-17-2006, 04:34 PM

thank you John

Abul Kashem

11-18-2006, 03:44 PM

hi problem with
http://www.a2plusdirectory.com/

please advise

dhowler

11-18-2006, 05:10 PM

Well, has anyone updated the upgrade script? Maybe it should have some sort of auto drop if found? I can't even get this to install, and I am so strapped for cash I certainly can't pay for someone to fix this for me.

Dave Baker

11-19-2006, 02:55 PM

Hello dhowler,
Maybe this offer about "professional upgrade from our team" will suit you:
http://www.esyndicat.com/forum/post51419-1.html

dhowler

11-23-2006, 01:26 AM

Hello dhowler,
Maybe this offer about "professional upgrade from our team" will suit you:
http://www.esyndicat.com/forum/post51419-1.html

Nope, that doesn't quite help me right now. I am very strapped for cash, especially with Christmas right around the corner. I guess I will just have to wait awhile for an upgrade. Oh well...

Dreamy

disenioweb

11-23-2006, 08:45 PM

I followed the steps to upgrade and have this error:

Error: Unknown column 't21.num_cols' in 'field list'
(SELECT t1.*, COUNT(DISTINCTROW t4.`id`) num_links, '0' `crossed`, t21.`num_cols` FROM `dir_categories` t1 LEFT JOIN `dir_flat_structure` t2 ON t1.`id` = t2.`id_parent` LEFT JOIN `dir_link_categories` t3 ON t2.`id_category` = t3.`id_category` LEFT JOIN `dir_links` t4 ON t3.`id_link` = t4.`id` AND t4.`status` = 'active' LEFT JOIN `dir_categories` t21 ON t1.`id_parent` = t21.`id` WHERE t1.`id_parent` = '0' AND t1.`id` >= 0 AND t1.`status` = 'active' GROUP BY t1.`id` ORDER BY t1.`` LIMIT 0, 10000) UNION ALL (SELECT t1.*, COUNT(DISTINCTROW t5.`id`) num_links, '1' `crossed`, t21.`num_cols` FROM `dir_categories` t1 RIGHT JOIN `dir_crossed` t2 ON t1.`id` = t2.`id_crossed` LEFT JOIN `dir_flat_structure` t3 ON t1.`id` = t3.`id_parent` LEFT JOIN `dir_link_categories` t4 ON t3.`id_category` = t4.`id_category` LEFT JOIN `dir_links` t5 ON t4.`id_link` = t5.`id` AND t5.`status` = 'active' LEFT JOIN `dir_categories` t21 ON t1.`id_parent` = t21.`id` WHERE t2.`id_category` = '0' AND t1.`status` = 'active' GROUP BY t2.`id` ORDER BY t1.`title` LIMIT 0, 10000)

What can i do ?

dinsol

12-04-2006, 10:47 AM

Looking Great and more profressional after upgrade.

Thanks :good:

Michael Hill

12-05-2006, 05:35 AM

Dan Miller

01-01-2007, 11:09 PM

I believe I have followed your update instructions exactally but am getting the following:

Error: Duplicate column name 'super'
ALTER TABLE `dir_admins` ADD `super` ENUM( '0', '1' ) DEFAULT '1' NOT NULL , ADD `status` ENUM( 'approval', 'active' ) DEFAULT 'active' NOT NULL , ADD `database` ENUM( '0', '1' ) DEFAULT '0' NOT NULL , ADD `editors` ENUM( '0', '1' ) DEFAULT '0' NOT NULL , ADD `config` ENUM( '0', '1' ) DEFAULT '0' NOT NULL , ADD `pages` ENUM( '0', '1' ) DEFAULT '0' NOT NULL , ADD `fields` ENUM( '0', '1' ) DEFAULT '0' NOT NULL , ADD `plans` ENUM( '0', '1' ) DEFAULT '0' NOT NULL , ADD `news` ENUM( '0', '1' ) DEFAULT '0' NOT NULL , ADD `theme` ENUM( '0', '1' ) DEFAULT '0' NOT NULL , ADD `language` ENUM( '0', '1' ) DEFAULT '0' NOT NULL;

Thanks in advance for any help!

Dan

billybh

02-13-2007, 03:15 AM

I am not sure what's going on, but I can't run the upgrade.php file. It does not confirm properly, so where did I go wrong with the upgrade?

I went through the whole SQL pre-upgrade inside the myPHPadmin console making sure it reached the very end, and correcting each error on the way. Does anyone have some time to take a quick look over why the upgrade.php file is not loading properly?

I will give you the credentials to the directory if need.

Just awesome, now it broke the whole administrative portion of the directory. Nightmare.

John Turner

02-13-2007, 03:59 AM

Hi billybh,

Why you try to use myPHPadmin it's necessary to use Manage Database -> Import.

billybh

02-14-2007, 02:17 AM

Michele

02-24-2007, 06:56 PM

How hard is it to repopulate the database in version Pro 2.1 with records from version Pro 1.2? Because at this point the upgrade process is trashed, and stuck in the middle. I would love to be able to do a fresh install with 2.1 and reload all the records.

"We offer free database migration from ANY other directory scripts. If you already have another directory or link exchange script we can migrate its database for eSyndiCat Directory Script!" - Is this offer good for existing owners or do you have a tool that would help older version owners to do it themselves?

One other thing, the manage database import export function has always been broke since I made the upgrade to Pro 1.2 that is why I had to do it via myPHPadmin.

I too would like to see some official comment on this. I have been working on installing/configuring a new clean version, but without migrating the old database it's all useless.

When the decision was made to change the structure of the database as part of the upgrade - you had to have known people were going to have problems.

imagis

02-27-2007, 04:58 PM

Hi,

I started been frustrated about upgrade from 1.2 to 2.0

I have in administration a links directory for other people using eSynd and on pre_upgrade step i am encountering lot of errors so i can't finish upgrade...

Sample of the first error (and i can get rid of it only if deleting some indexes into _links table, but then encountering more errors, aso):

Incorrect table definition; there can be only one auto column and it must be defined as a key.

So, i am stuck now, and can't go to 2.0 (i want 2.1 upgrade in fact)...

imagis

02-27-2007, 08:28 PM

Ok, bad things:
- migration from 1.2 to 2.0 is possible on database but gives errors: i solved manually those from pre_ step (categories table, index delete makes script failing i guess under some mysql configs - which on this server is something default) but then post_step it freeze

- ok, is no longer possible to switch from 2.0 to 2.1 since i can't find any 2.0 kits so i can put in place

- i tried a switch anyway but migration scripts is freezing.

Now, as a customer for a lot of other application, migration process seems to be worst i'we seen here, on eSyndicat :( And i work a lot of developing side so i am not an "idiot" who doesn't know how to make things...

I had to switch back to 1.2 at the end... Probably i would go to a manual tables comparison, and migrate tables who are really in use...

Now i remember with pleasure by moments when i had to migrate vBulletin, which is far a more complicated application, but except skins/templates + addons, the core of application is easy to update like a breeze...