ZeroDegreez Posted August 29, 2008 Posted August 29, 2008 Hello all Regarding, http://www.oscommerce.com/community/contributions,5750 I have FTP'd the files from the package but am unsure of how to run the SQL file on my database (described in the included manual). Could someone please help me? "To install, first run the MATC_Install.sql file on your database." What does this mean and how do I do it? Many thanks. Alis
keithwilliams Posted August 29, 2008 Posted August 29, 2008 Hello all Regarding, http://www.oscommerce.com/community/contributions,5750 I have FTP'd the files from the package but am unsure of how to run the SQL file on my database (described in the included manual). Could someone please help me? "To install, first run the MATC_Install.sql file on your database." What does this mean and how do I do it? Many thanks. Alis Hiya Alis, Had the same problem myself recently and once i'd sussed it, I couldn't believe how easy it was! so - here goes... First - BACKUP EVERYTHING! Your site, database the lot! The sql file will modify your database so a backup in case things go wrong is important! Second - Make absolutely sure you've backedup everything! Do you have a 'cPanel' with your web host? Any decent webhost will provide a control panel to manage your webspace, and also provide a tool within it called 'phpMyAdmin'. If you do - great! Log into your cPanel. Locate & run phpMyAdmin. Look top left in phpMyAdmin at the row of buttons - from left they're Home, Exit, SQL, then a couple with documentation. Click on the SQL button. This will bring up a 'Query' window. Next, open the SQL file supplied with the contribution in a simple text editor (like Notepad - NOT wordpad or msword) Copy ALL of the text in the SQL file, then paste it into the phpMyAdmin query window. Look bottom right, just under the query window for a 'GO' button & click it. The code you pasted in will now execute. That's it, you're done! Test your contribution and if alls well that great. If sonethings broken your site you can always use your backup to restore everything (you did backup first, didn't you?!) Hope this helps Regards Keith In life, try everything three times... First, just to see if you like it. A Second, to see if you were mistaken the first, And a third, to see if you tire of it quickly...
ZeroDegreez Posted August 29, 2008 Author Posted August 29, 2008 Hiya Alis,Had the same problem myself recently and once i'd sussed it, I couldn't believe how easy it was! so - here goes... First - BACKUP EVERYTHING! Your site, database the lot! The sql file will modify your database so a backup in case things go wrong is important! Second - Make absolutely sure you've backedup everything! Do you have a 'cPanel' with your web host? Any decent webhost will provide a control panel to manage your webspace, and also provide a tool within it called 'phpMyAdmin'. If you do - great! Log into your cPanel. Locate & run phpMyAdmin. Look top left in phpMyAdmin at the row of buttons - from left they're Home, Exit, SQL, then a couple with documentation. Click on the SQL button. This will bring up a 'Query' window. Next, open the SQL file supplied with the contribution in a simple text editor (like Notepad - NOT wordpad or msword) Copy ALL of the text in the SQL file, then paste it into the phpMyAdmin query window. Look bottom right, just under the query window for a 'GO' button & click it. The code you pasted in will now execute. That's it, you're done! Test your contribution and if alls well that great. If sonethings broken your site you can always use your backup to restore everything (you did backup first, didn't you?!) Hope this helps Regards Keith Hey Keith, Thank you SO much! It works fine - well I think so, everything seems OK and the Terms and Conditions tab is in the admin panel so I'm going to try and do the rest now. You're a star. I can't thank you enough! [Edit] OK, so now it's installed and nothing has changed. I've edited the settings in the Terms and Conditions tab but no checkbox appears or anything. Also, all my currency has reset to zero, i.e. all products are listed as "0." Any ideas? Alis
keithwilliams Posted August 30, 2008 Posted August 30, 2008 Can someone help please? If you've changed your default currency in admin you also need to change it in catalog/includes/languages/English.php (often a cause of '0' prices) around line 39 find: define('LANGUAGE_CURRENCY', 'USD'); MAKE A BACKUP FIRST! then change the USD to Currency code that you want to use. (eg for the UK you'd use GBR) Also, if the contribution doesn't work as expected, (or at all) and the contribution is for your version of OSC, then it's almost always that you've make an error when making the changes to your files. You need to be VERY careful that you don't inadvertantly overwite some code that you shouldn't. Or perhaps you've missed a change. It's often easier to use a file compare program to add contributions. I use 'Beyond Compare' which is superb but not free. A good free one is WinMerge. you can find both with google... Hope this helps! In life, try everything three times... First, just to see if you like it. A Second, to see if you were mistaken the first, And a third, to see if you tire of it quickly...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.