[cheebs]

I followed the clean install instructions, copied my database over and ran the sql file and the update php script. Most categories load just fine, but the categories that have hundreds of products doesnt load at all.

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?

[mdekok3000]

Okay, if the instructions didn't work for you like they did for me, you could try...

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.

[louwie]

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

[louwie]

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 ?

[louwie]

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....

[Miss Marple]

Thank you very much for your workaround, Matt! It was very helpful!

...

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).

[moka]

ok, I'm trying to follow along here, but I' already stuck! I have no idea how to duplicate my database on cpanel (hostgator). Any help would be much appreciated. thank you!

[Alfie]

Best bet would be to backup your existing one (live) and, if you have the facility, create a new databse and import/restore all your content to the new database and work on that one, thus leaving the old one (current live) well alone....

Alfie

[jobosales]

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

[ThomH]

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.

[cheebs]

I'm having nothing but trouble with this release. I downloaded and installed the 1.3.5 sp3 full file set, installed it, but can never login to the admin area!! I've installed it 5 times using several different browsers, even redownloaded the files a few times.

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

[zardos]

Cheebs,

Have you checked your file and folder permissions.

[cheebs]

Yes, all the file/folder permissions are set the same as the working store I have running sp2.

I have no idea why its not letting me login. Everything in the database looks fine too.

[cheebs]

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.

??

[JesseLeeStringer]

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.

[cheebs]

success!
I was only clearing my cache before and not the cookies.

Thank You!

[moka]

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!

[JesseLeeStringer]

I get a time out error message. What am I doing wrong? thanks!

It's too big,

Open the database file, copy and paste 50% of the text so that it can be read correctly and upload one at a time.

[mdekok3000]

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.

[JesseLeeStringer]

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