Hi, i'm trying to update my very old version to the latest one. Since i don't want to mess up the old site until the update is ready, i want to make a backup from the old site, update is and then replace the old one. So i have: - Upload the old files to a temporary subfolder - Exported the old database en imported it to a new database But no i want to connect the new temporaty site to the new database, after which i can start to upgrade. But in which file do i change the name en password of the database. I can't seem to find it.
Just from experience in having to do this for a couple of different clients. Although the "upgrade" process allows you to upgrade from 3.1.x versions there are some definite issues in doing so due to incompatibilities and features. There are no memberships in ANY version of 68 Classifieds v4.0 and later! Do to differences in the db and functions for admin created pages, you will need to open each of your individual pages in the admin and resave them in order for the page links in your menus to work. You're old templates will not work properly with the newer version. You will need to go through and compare each template file to compare any of the "smarty" code as there are different smarty variables assigned as well as the simple fact that the templates themselves have a suffix of ".tpl" instead of the old naming convention of ".tpl.php". There were other more minor items as well, but alas, I didn't document them and can't remember any more off the top of my head. I do seem to remember having to actually make some changes directly in the database using phpMyAdmin. I guess you can't complain as 68 Classifieds v3.1 is well over 5 years old, so in dog years... I mean technology years... That's like a D-I-N-O-S-A-U-R !!!
I have noticed the issues, but managed to solve most problems! However, when i try to insert the New listings code in the home.tlp Code: {new_listings number=8 cols=3} the following code appears at the bottom: Code: Notice: Query failed: Unknown column 'p.id' in 'field list' SQL: SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pHighlighted, p.pBold, u.state, u.city, u.country FROM class_products AS p LEFT JOIN class_users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ORDER BY p.dateadded DESC LIMIT 8 in /var/www/html/includes/classes/database/mysql.php on line 251 Can i use this code in my updated script?
Do you still have the old plugin installed or something? That code is NOT right! It should be a "... FROM ".PREFIX."listings AS p..."
Well, i don't know. I went trough the updateproces, but i did not remove any files. How can i see if the old plugin is installed or the new one? Do i have to remove or replace the code and in which file?
Just delete it on the server and then upload the file from the latest version. Of course you could just use the listings plugin which is used on the default home page. I personally like the new "listings" plugin much better than any of the others, because it is so much more versatile, especially if you just assign it to a variable as they do in the default hompage. That way you can use a smarty foreach and display them however you want to instead of those horrible tables! Just saying! I'm just using the listings plugin on my gadgets (still in beta) site. See what I did just with foreach and css.
Nice, very nice what you did!! But which files do i need to delete and which new files do I deed to update? And do you know the name of the tlpl dat shows the listings in a category? Like here: http://www.autostot1000euro.nl/categories/alfa-romeo/page/1.html I would like insert adsense, but cannot find the tpl. In my old script, i was able to rename categories in the URL to advertenties. I made a change to the .htaccess, but cannot remember how i did this? Do you know how to do this?
Doing the "upgrade" process in the setup has nothing to do with the files themselves. That only addresses the database itself and inserts the value of the newer version into the database. Before you went through that process you had to upload all of the NEW files to your server. What I'm saying is that plugin is the OLD one or a modified one. Either delete it and upload the new version or upload the new version and overwrite the old one. OR as I suggested just use the new "listings" plugin instead. As far as knowing what template you are using on ANY page, use the smarty debug as defined in the online documentation. That page is either the showlistings or showlistings2 depending on which you have set in admin. (I don't know from looking, because it's been modified.)
