|

Service pack 3 for CS-Cart 1.3.5 is released!
Posted 14 April 2008 - 11:42 PM #41
Please check it out... (choose an auto part category on the left) http://www.ineedparts.com/new_store/
Everything worked fine in sp2. Any thoughts?
Posted 15 April 2008 - 12:15 AM #42
1. Do a clean install of SP3 to a "new_store" folder. Use a different db name.
2. Export your products and images from the old store, then import them into the new one.
3. If this works, then try reinstalling mods and testing one at a time.
[/SIZE]
Posted 15 April 2008 - 06:38 AM #43
on my ideal page i see some errors. resultcode: "Please adjust expiration period. See suggested expiration period"
txn request: <?xml version="1.0" encoding="UTF-8"?><AcquirerTrxReq xmlns="http://www.idealdesk.com/Message" version="1.1.0"><createDateTimeStamp>2008-04-15T05:41:39.0Z</createDateTimeStamp><Issuer><issuerID>0721</issuerID></Issuer><Merchant><merchantID>.......
txn reply: <?xml version="1.0" encoding="UTF-8"?>
<ErrorRes xmlns="http://www.idealdesk.com/Message" version="1.1.0">
<createDateTimeStamp>2008-04-15T05:41:39.639Z</createDateTimeStamp>
<Error>
<errorCode>AP2920</errorCode>
<errorMessage>Please adjust expiration period. See suggested expiration period</errorMessage>
<errorDetail>Field generating error: expirationDate too low</errorDetail>
i think its something that the expiration period is to short...but is it an error in sp3 or on my hosting server? because i see there is a diference in the time by ideal and on my hosting server
Posted 15 April 2008 - 09:48 AM #44
yesterday i did the upgrade from form 1.3.5 sp2 to sp3. everything seems to work fine, only ideal basic gives an error....
on my ideal page i see some errors. resultcode: "Please adjust expiration period. See suggested expiration period"
txn request: <?xml version="1.0" encoding="UTF-8"?><AcquirerTrxReq xmlns="http://www.idealdesk.com/Message" version="1.1.0"><createDateTimeStamp>2008-04-15T05:41:39.0Z</createDateTimeStamp><Issuer><issuerID>0721</issuerID></Issuer><Merchant><merchantID>.......
txn reply: <?xml version="1.0" encoding="UTF-8"?>
<ErrorRes xmlns="http://www.idealdesk.com/Message" version="1.1.0">
<createDateTimeStamp>2008-04-15T05:41:39.639Z</createDateTimeStamp>
<Error>
<errorCode>AP2920</errorCode>
<errorMessage>Please adjust expiration period. See suggested expiration period</errorMessage>
<errorDetail>Field generating error: expirationDate too low</errorDetail>
i think its something that the expiration period is to short...but is it an error in sp3 or on my hosting server? because i see there is a diference in the time by ideal and on my hosting server
i think i know where the problem is, when i put the timezone in cs-cart to "gmt-1 azores" and after that i take a look at php info from cs-cart i see Default timezone Etc/GMT+1

And when i put the time zone to gmt+1 amsterdam, in php info i see gmt-2
and now the question: where to fix this???? can someone help me?
i had contact with my hosting company and the server time is fine gmt+1 so its must be in cs-cart 1.3.5 sp3 ?
Posted 15 April 2008 - 10:34 AM #45
i think i know where the problem is, when i put the timezone in cs-cart to "gmt-1 azores" and after that i take a look at php info from cs-cart i see Default timezone Etc/GMT+1
![]()
And when i put the time zone to gmt+1 amsterdam, in php info i see gmt-2
and now the question: where to fix this???? can someone help me?
i had contact with my hosting company and the server time is fine gmt+1 so its must be in cs-cart 1.3.5 sp3 ?
i placed a new thread in bugs....
Posted 15 April 2008 - 03:13 PM #46

...
error in syntax near KEY `src_k`; please check you documentation for the correct sytax to use near `src_k`; it cant seem to do these queries;ALTER TABLE cscart_product_prices DROP COLUMN KEY `src_k`; ALTER TABLE cscart_product_prices DROP COLUMN KEY `unique_key`; ALTER TABLE cscart_product_prices DROP ADD UNIQUE KEY `unique_key` (`lower_limit`,`membership_id`,`product_id`);
I just had the same problem as Alfie. First message was that it couldn't drop column combination_id in product_prices, and then the rest of Alfie's sql errors.
ALTER TABLE cscart_product_prices DROP COLUMN `combination_id`;
So I made a copy of my "old" table cscart_product_prices, deleted the column combination_id and the unique key "src_k" by hand and exported the data without structure. Then I imported the data into the 1.3.5.SP2 cscart_product_prices.
Could it have something to do with how prices are displayed? Mine are comma-separated (German).
Miss Marple
PHP Version 5.2.11
MySQL 5.1.36
Linux/Apache/1.3 (Unix)
CS-Cart 2.1 (still customizing)
Posted 17 April 2008 - 06:46 AM #47
Posted 17 April 2008 - 12:07 PM #48
Alfie
Posted 17 April 2008 - 11:18 PM #49
Log into your Cpanel control panel and click on the Backups icon under Files. You can back up your database by clinking on its name under "Download a MySQL Database Backup" in the Partial Backups section. I always perform a full backup at the same time just in case I do something stupid.
Bob
Posted 19 April 2008 - 04:18 PM #50
I didn't find to fix:
PayPal Open Orders in Admin Module (#701)
or I'm blind.
Fixed. (this means I'm blind)
Works fine in our webshop.
WebGraphiq offers a wide range of professionally developed, ready to use CS-Cart add-ons to provide additional functionality and boost your sales. The oldest active CS-Cart add-on development team. -- Since 2006 --
CS-CART ADD-ONS | FREE QUOTE | CS-CART DEVELOPMENT | @webgraphiq
Posted 20 April 2008 - 02:06 AM #51
It says to use admin/admin as the login, but it never lets me in. I've also tried my email and several other combinations, but nothing.
This is getting really frustrating!
Any thoughts??
Thanks
Posted 20 April 2008 - 10:28 PM #53
I have no idea why its not letting me login. Everything in the database looks fine too.
Posted 20 April 2008 - 11:45 PM #54
??

Posted 21 April 2008 - 03:20 AM #55
I logged in successfully just now using windows/IE, but no browser on my mac will let me login! I tried Firefox, Safari, Camino and Opera to no avail. I've been using sp2 just fine on my mac, but sp3 is only working (logging me in) under windows.
??
Clear all your cookies relating to this domain.

Posted 21 April 2008 - 04:40 PM #56
I was only clearing my cache before and not the cookies.
Thank You!
Posted 21 April 2008 - 09:58 PM #57
moka-
Log into your Cpanel control panel and click on the Backups icon under Files. You can back up your database by clinking on its name under "Download a MySQL Database Backup" in the Partial Backups section. I always perform a full backup at the same time just in case I do something stupid.
Bob
Ok, I got that far. Now for stupid question #2. How do I upload this into a new database name. I can only seem to "restore" it to the original database. When I tried to import it via phpmyadmin via import, I get a time out error message. What am I doing wrong? thanks!
Posted 21 April 2008 - 11:10 PM #58
It's too big,I get a time out error message. What am I doing wrong? thanks!
Open the database file, copy and paste 50% of the text so that it can be read correctly and upload one at a time.
Posted 21 April 2008 - 11:32 PM #59
I personally have about 27,000 records in my stat_ip2nation table.
[/SIZE]
Posted 21 April 2008 - 11:47 PM #60
Mostly it's the language_values, stat_ip2nation, and possibly stat_requests and stat_sessions tables. The rest all load together fine.
I personally have about 27,000 records in my stat_ip2nation table.
I deleted that entire table along with the rest of ip2nation.
Don't use it, hence useless