Printable View
I didn't get any response to this question, but tried to install over an existing install and it choked, so removed the contribution file by file and installed from scratch with latest version. Everything works fine now.Quote:
Originally Posted by ronlee67
Ron
That is generally the best method when installing mods. As you can never be certain if the updated mod version does or doesn't include the exact same file set as the previous version, it can be easy to miss deleting a no longer used previous version file (even when you follow the readme).Quote:
Originally Posted by ronlee67
And when upgrading mods, I always open the provided SQL patch to compare SQL differences between previous versions, so I know what to expect when I view the relevant mod menus in the admin GUI.
Sometimes if I have trouble with a mod install I run the uninstaller SQL patch and reinstall the SQL from scratch (rather than running the updater SQL). But not all mods provide such ability. Note Andrew most often provides uninstaller and updater SQL patches with his mods. Very good service.
And thanks to Andrew for providing the RCS mod update.
Woody
Hi Andrew.
Installed Andrew's RCS mod update (Apr 1 2007).
Whenever a Recover Cart email is sent to a customer with an abandoned shopping cart and then customer returns and submits an order, as expected their order is displayed in Admin > Reports > Recovered Sales Reports
When order is in pending status report shows:
After the order status is updated (changed from pendng to to processing or shipped) the report shows:Code:Examined Records: 1
Recovered Sales: 1
SCart ID Date Added Customer Name Order Date Status Amount
2 12/31/1969 Joe Tester
Total Recovered: 100% $0.00
As can be observed above:Code:Examined Records: 1
Recovered Sales: 1
SCart ID Date Added Customer Name Order Date Status Amount
2 12/31/1969 Joe Tester 04/28/2007 Shipped $17.00
Total Recovered: 100% $17.00
1. in both cases the 'Date Added' is incorrect.
2. when order is pending status the 'Order Date', 'Status', and 'Order Amounts' are NOT displayed.
Can anyone using this mod confirm similar behavior?
Thanks,
Woody
i keep getting the following error which i cant understand because everything has been running fine and i haven instaled any other add ons latelty:
anyone got any ideasQuote:
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 'Callaghan') and o.orders_status > 1 and s.orders_s' at line 5
in:
[select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from modchipfittersorders o left join modchipfittersorders_total ot on (o.orders_id = ot.orders_id), modchipfittersorders_status s where (o.customers_id = 2235 OR o.customers_email_address = '' OR o.customers_name like 'Sean O'Callaghan') and o.orders_status > 1 and s.orders_status_id = o.orders_status and o.date_purchased >= '20070414' and ot.class = 'ot_total']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Recover Cart Sales Report v2.00
its only from the report screen the other half of the mod works fine including emailing my customers
Download and try last variant.
Hi Andrew, found small issues with the 04-29-07 mod update (missing semi-colon in SQL updater and problem with data displaying report). PM'd you details.Quote:
Originally Posted by a_berezin
Thanks,
Woody
Hi Woody,
Thank you. I fix it. Download and test.
Don't use update_1.sql!!! Sorry :no:
just downloaded the latest version from your site but i get this error when trying to update the sqlQuote:
Originally Posted by a_berezin
Quote:
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 '; = 0' at line 1
in:
[CREATE TABLE modchipfittersscart ( scartid int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', dateadded varchar(8) NOT NULL default '', datemodified varchar(8) NOT NULL default '', PRIMARY KEY (scartid), UNIQUE KEY customers_id (customers_id), UNIQUE KEY scartid (scartid) ) TYPE=MyISAM; = 0;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Ohh! Yes, some typo in sql file. Thanks, fixed it.
But, why you start to update sql? Where you read about this?
ok that fixed the last error but now im getting the following error when trying to install the sqlQuote:
Originally Posted by a_berezin
Quote:
1054 Unknown column 'cofiguration_group_title' in 'where clause'
in:
[SELECT (@t4:=configuration_group_id) as t4 FROM modchipfittersconfiguration_group WHERE cofiguration_group_title= 'Recover Cart Sales';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.