eSyndiCat Pro v1.1 - v1.2 SQL upgrade!

[Simon Gooffin]

Hi again,
I have prepared a file to upgrade from your Pro 1.1 version to Pro 1.2. Please follow these instructions:

#1. MAKE A FULL BACKUP OF YOUR DATABASE AND FILES
#2. Download upgradev12.zip from your Pro downloads area
#3. unpack it. it should contain the following:
convert_pro_12.php
updates\upgrade_Pro_v11_v12.sql
#4. upload this unpacked content to your esyndicat directory
#5. login to your admin panel
#6. patches and upgrades
choose upgrade_Pro_v11_v12 from a list and click Run SQL Update
#7. reupload all the files from eSyndiCat Pro 1.2 archive except includes/config.inc.php and 'install' directory
#8. add the following lines to your includes/config.inc.php file:
$gDirConfig['version'] = 'eSyndiCat Pro v1.2';
$gDirConfig['categories_order'] = 'title';
#9. reset permissions to your directories and files
chmod 777 backup/
chmod 777 includes/config.inc.php
chmod 777 tmp/
chmod 777 uploads/
chmod 777 language/*
#10. now run convert_pro_12.php from your browser


That's all. Then login as admin and choose GreenLeaves template. It's the only template available for our 1.2 version. All the other templates will be ready within next few days.
Thanks for your patience. Let me know if you have any questions.

[klhavlik]

Simon --

Regarding templates...you say that only the GreenLeaves is available. I've made my own template using one of the previous templates as a basis. What do I need to do to 'upgrade' my template to use with 1.2?

Kelly

[tina]

I followed these instructions and it worked like a charm :D Since its the middle of the week and I don't have much time to work on it, I didn't want to have my directory off line so I used a backup copy of my directory. However the copy was exactly the same so I am confident about applying this update to my production version.

On my site's template, I've made extensive changes to it. I initially chose that as my template and the home page displays perfectly. However if I click on any categories, the url changes but I remain on the main page. I am aware that the 1.1 templates are not compatable with version 1.2, however I am just wondering if there are major changes I am going to have to make or if its only going to be a few tags?

So far I am very happy with what I see, nice work Simon :)

Be well,
Tina

[Fredy]

I have been trying to download eSyndiCat_Pro_v12.zip from the download page, but each time the file can't be opened "File may be corrupt"

Maybe your zip is damaged?

If not do you have an FTP location I can retrieve it from?

FREDY :wallbash:

[eddy2099]

Freddy, I find that if you use IE to download and if it finds the same file existing on your computer or in its cache, it doesn't do the actual download but just draws from the cache no matter how corrupted it is.

You will need to clear the cache and delete the copy of the failed download and restart IE to try again.

Alternatively, when you download, when you are prompted for the option of where to save the file and the filename, change it to something else to allow for a full download. If that fails, use another bweb browser.

[tina]

Well I take it back. All of a sudden my category links are working on my modified template :) I am still things through their paces however right now it appears that my customized template from 1.1 is working fine with version 1.2.

Be well,
Tina

[eddy2099]

I was just experimenting around and yes the v1.1 templates would work with v1.2 as far as my test goes however it appears that there are some v1.2 features which would not work with the v1.1 templates such as captcha (sp ?), the payment module and the add on upload fields.

[tina]

Yes I think you are correct on that. I tried turning the captcha feature on and it did not display, which of course makes perfect sense. So just a little more tinkering :)

Be well,
Tina

[Simon Gooffin]

I will clarify the situation about templates..
eSyndiCat Pro 1.1. templates do not work on 1.2. That's true. Now our SunnyDay and FireAndIce templates are almost completed. I will try to explain the easiest way to upgrade your templates. The main changes should be around Smarty tags. Here is how we upgrade our current templates:
#1. CREATE A BACKUP of your working templates
#2. Compare 3 main files. They are: header.tpl, footer.tpl and index.tpl.
#3. Then reupload your other template files from the same template directory of eSyndiCat 1.2
#4. Make some tweaking in order to fit your site design.

We will try to complete upgrading all our templates within this week. Let me know if you need any advice

[redeye]

Ran everything as per instructions and get when running convert_pro_12.php

$gDirConfig['version'] = 'eSyndiCat Pro v1.2'; $gDirConfig['categories_order'] = 'title';Can't use database : No database selectedCan't use database : No database selected

[Simon Gooffin]

did you add these lines before
?>

? It looks like you have broken config.inc.php file

[redeye]

did you add these lines before
?>

? It looks like you have broken config.inc.php file

Before what Simon?

I just added the code to the config

[Simon Gooffin]

did you add these code lines to the very end of config.inc.php file? it looks like you did. You should have inserted this code:
$gDirConfig['version'] = 'eSyndiCat Pro v1.2';
$gDirConfig['categories_order'] = 'title';

in the end before ?> symbols.

[redeye]

did you add these code lines to the very end of config.inc.php file? it looks like you did. You should have inserted this code:
$gDirConfig['version'] = 'eSyndiCat Pro v1.2';
$gDirConfig['categories_order'] = 'title';

in the end before ?> symbols.

I think I screwed up!

I added the lines to the config.inc.php in the 1.2 archive

I now think I should have added them to the end of the original config.inc.php

[Simon Gooffin]

It seems I was not clear enough. Of course, you should add these lines to your installed Pro 1.1 config.inc.php file.

[redeye]

Is there any way I can retrieve the situation?

I don't have a copy of the original file, only an sql dump.
Can I use part of the dump to re-construct the original file?

[Simon Gooffin]

yes, there is a way. please email me your dump. I will generate config.inc.php file for you :)

[redeye]

I'll get it to you asap - but may have to wait until I return home tonight (18.00 GMT)
Thanks Simon.

[Simon Gooffin]

np, anytime when it's more convenient for you. configs table data would be enough

[Taipa]

#2. Merge 3 main files. They are: header.tpl, footer.tpl and index.tpl.


When we merge these 3 files, what do we call the new file? index.tpl?

[Taipa]

Ah, I thought of another interpretation.

"Merge 3 main files" = "Compare and merge each of the 3 main files with the new 1.2 versions of those files"?

[Shannon Hutcheson]

I followed Simon's instructions *exactly* and had no errors on upgrading my eSyndiCat.

Thank you for the flawless upgrade Simon :good: :yahoo: :kiss:

[Greg]

Ah, I thought of another interpretation.

"Merge 3 main files" = "Compare and merge each of the 3 main files with the new 1.2 versions of those files"?

I think ? Simon means to overwrite those three files. (but you may want to see what he has to say first :)
Make sure you backup all of your files first.

[Taipa]

I tried that, but it screws the layout (because they're obviously set up for the GreenLeaves layout specifically). ^_^
I ended up doing the compare & merge for each file, and adding additional components from the new index, header, and footer from GreenLeaves into my current layout files.

Then a bunch more tweaking for asthetics, and I've got a proper working layout! ^_^

[Anonymous]

Yes Simon, Please kindly let us know when the Fire and Ice template is done.

[Greg]

Taipa

Sorry about that. That wa stupid of me. I should know better. :wallbash:

[Simon Gooffin]

"Merge 3 main files" = "Compare and merge each of the 3 main files with the new 1.2 versions of those files"?
Exactly. I have just edited my post to get rid of confusion..

2 Shannon:
I tried to make it as easier as possible. I wish I could offer something similar for templates but now I can not do that :( More functionality needs more template modifying.

[echopulse]

Simon,

I started all over, and re-installed the original version. Then I followed the instructions. The only problem this time, is that the convert file did not add the some of the new tables. So I added them myself, using the appropriate sections of the sql file included in the install folder. Now, everything appears to work, and my categories show up, but my links don't.

The Root category appears as a normal category in the category list as well.

[thenetcode]

I followed all this, but all the links in my directory are now gone. I have backups of everything, but not sure how to get all the links back that I created and all the categories I had.

Kevin

[thenetcode]

Ok that is weird. At first all my links were not showing and then after a few minutes they were all there. So go figure that. Any rate. The upgrade looks good so far. Have to make changes to the template colors, but all and all it is working well so far.

Kevin

[Simon Gooffin]

My considerations about disappeared links. I think something wrong with link_categories table. Please check this table, if it contains any records

[OWG]

I ran it, and it went a drem, but I went into admin, clicked on modules, and got

Warning: main(../plugins/simg/meta.php): failed to open stream: No such file or directory in /home/ituk/B3JVJ0BC/htdocs/admin/manage-modules.php on line 93

Fatal error: main(): Failed opening required '../plugins/simg/meta.php' (include_path='.:/usr/local/lib/php') in /home/ituk/B3JVJ0BC/htdocs/admin/manage-modules.php on line 93

Something is wrong. I know it is me that has done something wrong, it always is :D

[Greg]

OWG

Please see this.
http://www.esyndicat.com/forum/viewtopic.php?t=1831

Actually Simon you should place that "Sticky" in this forum. :)

[OWG]

Cheers Greg,

Maybe a sticky covering all the little 'features' (notice we have adopted the Microsoft approach) :D with links to each thread would save a lot of duplication. Bugs are to be expected on a new version, and it would make life easier for you guys as well as those who install the script. :)

Tell me to bugger off an mind my own business if you like though ;)

[dousma]

You say reupload all the files from the archive, do you mean I have to download first the complete version 1.2 and than upload all these files to my eSyndiCat map?

[OWG]

Yes that is what I did,

Downloaded both the update file and the 1.2 version files, then uploaded the new files.

[Animal Makers]

OK, I followed your instructions to the letter and when I run

http://www.animalmakers.com/links/convert_pro_12.php

I get an Internal Server Error. I get this same error I run the main script, the admin script, etc...

HELP

[Animal Makers]

The problem seems to be in the .htaccess file.

I used the one your provided that says:
---------------------------------------
# enable mod_rewrite
RewriteEngine on

# mod_rewrite rules for categories pages
RewriteRule ^(.*)/$ index.php?category=$1 [QSA,L]
RewriteRule ^(.*)/index([0-9]+).html$ index.php?category=$1&page=$2 [QSA,L]

# mod_rewrite rule for suggest link page
RewriteRule ^suggest-link([0-9]+).html$ suggest-link.php?id=$1 [QSA,L]

# mod_rewrite rules for new links page
RewriteRule ^new-links.html$ new-links.php [QSA,L]
RewriteRule ^new-links([0-9]+).html$ new-links.php?page=$1 [QSA,L]

# mod_rewrite rules for top links page
RewriteRule ^top-links.html$ top-links.php [QSA,L]
RewriteRule ^top-links([0-9]+).html$ top-links.php?page=$1 [QSA,L]

# mod_rewrite rules for popular links page
RewriteRule ^popular-links.html$ popular-links.php [QSA,L]
RewriteRule ^popular-links([0-9]+).html$ popular-links.php?page=$1 [QSA,L]

# mod_rewrite rules for editors links page
RewriteRule ^editor-links/index.html$ editor-links.php [QSA,L]
RewriteRule ^editor-links/index([0-9]+).html$ editor-links.php?page=$1 [QSA,L]

# mod_rewrite rules for view link page
RewriteRule ^(.*)/(.*)-l([0-9]+).html$ view-link.php?cat=$1&title=$2&id=$3 [QSA,L]

# mod_rewrite rules for news page
RewriteRule ^news.html$ news.php [QSA,L]
RewriteRule ^(.*)-n([0-9]+).html$ news.php?title=$1&id=$2 [QSA,L]

# mod_rewrite rules for additional pages
RewriteRule ^p(.*).html$ page.php?name=$1 [QSA,L]

# mod_rewrite rules for error pages
RewriteRule ^([0-9]+).htm$ error.php?error=$1 [QSA,L]

ErrorDocument 500 /dir/500.htm
ErrorDocument 404 /dir/404.htm
ErrorDocument 403 /dir/403.htm
ErrorDocument 401 /dir/401.htm
---------------------------------------

Obviously, I changed the path of the "ErrorDocument" lines to files of my choosing since you did not provide any.

[Nick Collins]

Hi Animal Makers, I would recommend you to remove convert_pro_12.php file from your server, as this problem doesn't exist anymore.

[Animal Makers]

Removed. Thank you.

How did the problem get fixed? I did not do anything. Was it because that file was still in the directory?

[Nick Collins]

I have clicked to the link you provided and saw that update was ended successful. That's all... :)

[readvolumes]

Hello,

I've just tried to upgrade from pro 1.1 to pro1.2.

I have followed the instructions as per the begining of this thread, and having run convert_pro_12.php from my browser was informed that the upgrade had worked, however I have encountered the following problems;

- The login page for the admin panel has the following text at the top of the page;

$gDirConfig['version'] = 'eSyndiCat Pro v1.2'; $gDirConfig['categories_order'] = 'title';

- The actual front end of the directory produces this;

$gDirConfig['version'] = 'eSyndiCat Pro v1.2'; $gDirConfig['categories_order'] = 'title';
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /....../musicdirectory/classes/DirDb.php on line 111
Unknown column 't1.' in 'order clause'

- When I log into the admin panel I get this;

$gDirConfig['version'] = 'eSyndiCat Pro v1.2'; $gDirConfig['categories_order'] = 'title';
Warning: Cannot modify header information - headers already sent by (output started at /....../musicdirectory/includes/config.inc.php:332) in /......../musicdirectory/admin/login.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at /......./musicdirectory/includes/config.inc.php:332) in /....../musicdirectory/admin/login.php on line 31

Warning: Cannot modify header information - headers already sent by (output started at /......./musicdirectory/includes/config.inc.php:332) in /........./musicdirectory/admin/login.php on line 32

Warning: Cannot modify header information - headers already sent by (output started at /......./musicdirectory/includes/config.inc.php:332) in /........./musicdirectory/admin/login.php on line 33

Warning: Cannot modify header information - headers already sent by (output started at /............./musicdirectory/includes/config.inc.php:332) in /......../musicdirectory/admin/login.php on line 35

The directory can be viewed at http://www.readvolumes.com/musicdirectory/
Can anyone help??

Thanks

Ed

[readvolumes]

Done it - realised I had put the;

$gDirConfig['version'] = 'eSyndiCat Pro v1.2';
$gDirConfig['categories_order'] = 'title';

at the very end of the config file, whilst it should be at the end, but before the ?>

Regards

Ed

[Nick Collins]

at the very end of the config file, whilst it should be at the end, but before the ?>
Sure ;)

[corfuholidays]

Solved. Thanks

[Nick Collins]

You are welcome to our forum, corfuholidays!

[MKJ]

Bit of an headache having to totally upgrade when you are using a modified theme for sure. These upgrades on this new script are really worthwhile having but implementing them is another matter when your site is developing. I am just wondering how these upgrades can be incorporated a bit easier. From your point of view I can see that you are doing amazing work and everything is as it should be. I take my hat off to you but for us users who are using your scripts on a working site it is another matter. How can I make these alterations a less painful process? An upgrade from one version to another is a major undertaking on my site. The problem lies with the themes. If you made a default theme perhaps that is always going to be upgraded I could concentrate on that one and learn how it is constructed. What do you think? I am trying to upgrade my site - one part of it - but it is getting scary now my site is growing and getting more and more visitors.

Regards
MKJ

[Nick Collins]

Hello MKJ!
We always upgrade our templates from version to version, so in case you changed nothing, you can simply upload new template version to your site. Otherwise you should compare some tpl files. Unfortunately there is no another way. In case it hard for you, we can make it for a small fee.