New Server Combinations Tab Inaccessible, Add To Cart Doesnt Work On Items With Combinations

[Briguyyyy]

Greetings,

 

I have a live site and working on moving it to another server.  Backed up all the files (except the cache which can be manually cleared), moved it over.  Backed up and imported database.  I have access to all information and everything seems to work.  The only error i discovered is when i go to add to cart on some items i get the:

 

Impossible to add the product to the cart.
textStatus: 'parsererror'
errorThrown: 'SyntaxError: Unexpected token a'
responseText:

 

If i go into the product to look at combinations i get a Tab: Combination (500) error.  I am unsure what happaned but tried moving it over twice and happened twice.  

 

PrestaShop Version 1.6.1.1

SQL version 5.6.27

PHP version 5.5.30

 

Anyone have any ideas on this issue?  I have attached a .pdf of the debug.

Products11.pdf

Edited December 9, 2015 by Briguyyyy (see edit history)

[PrestaHeroes USA]

I suggest running on new server a PrestaShop install, you can download here.

 

then if there is any compatibility issue PS should make you aware of it, where a 'move' does not tell us this information, so you can also do this:.

 

also on existing back office-->advanced parms-->configuration option, there may be report of incompatibility (note: this is good information to post as you  did not state your php version)

[Briguyyyy]

Do you mean compatibility in terms of server?  I had installed a fresh copy of presta to play around before i deleted and then moved mine over....

[PrestaHeroes USA]

Do you mean compatibility in terms of server?  I had installed a fresh copy of presta to play around before i deleted and then moved mine over....

 

lol..yes, but tis the game of 20 questions..  

[Briguyyyy]

lol... *facepalm*  

 

Anyone that can run me through the process of what I must do to get it right?

[PrestaHeroes USA]

Post this

also on existing back office-->advanced parms-->configuration option, there may be report of incompatibility (note: this is good information to post as you  did not state your php version)

 

 

and for 500 errors, turn them on get the exact error

https://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information-blank-page-500-internal-server-error/

 

only 17 more questions...

[Briguyyyy]

 CONFIGURATION INFORMATION

This information must be provided when you report an issue on our bug tracker or forum.

 SERVER INFORMATION

Server information Linux #1 SMP Tue Nov 3 19:10:07 UTC 2015 x86_64

Server software version Apache/2.4.16 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 mod_fcgid/2.3.9

PHP version 5.5.30

Memory limit 128M

Max execution time 90

 DATABASE INFORMATION

MySQL version 5.6.27

MySQL server localhost

MySQL name

MySQL user

Tables prefix ps_

MySQL engine InnoDB

 STORE INFORMATION

PrestaShop version 1.6.1.1

Shop URL

Current theme in use default-bootstrap

 MAIL CONFIGURATION

Mail method You are using the PHP mail() function.

 YOUR INFORMATION

Your web browser Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.73 Safari/537.36

 CHECK YOUR CONFIGURATION

Required parameters OK

Optional parameters OK

Edited December 10, 2015 by Briguyyyy (see edit history)

[Briguyyyy]

After turning on dev and going to frontpage i now have these errors:

[PrestaShopDatabaseException]

Data truncated for column 'total_charges' at row 1

INSERT INTO `ps_usps_cache` (`id_cart`, `id_carrier`, `hash`, `id_currency`, `total_charges`, `is_available`, `date_add`, `date_upd`) VALUES ('437', '78', '52884bcc5e431988d74ec82335009aa5', '1', '', '0', '2015-12-09 18:31:48', '2015-12-09 18:31:48')

 

at line 791 in file classes/db/Db.php

786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }

 

• DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 102 - tools/profiling/Db.php] - [1 Arguments]
• Db->query - [line 763 - classes/db/Db.php] - [1 Arguments]
• DbCore->q - [line 514 - classes/db/Db.php] - [2 Arguments]
• DbCore->insert - [line 371 - classes/db/Db.php] - [6 Arguments]
• DbCore->autoExecute - [line 1436 - modules/uspscarrier/uspscarrier.php] - [3 Arguments]
• UspsCarrier->saveOrderShippingCostCache - [line 1616 - modules/uspscarrier/uspscarrier.php] - [2 Arguments]
• UspsCarrier->getOrderShippingCost - [line 3004 - classes/Cart.php] - [2 Arguments]
• CartCore->getPackageShippingCost - [line 661 - classes/Carrier.php] - [5 Arguments]
• CarrierCore::getCarriersForOrder - [line 1357 - classes/Carrier.php] - [4 Arguments]
• CarrierCore::getAvailableCarrierList - [line 1863 - classes/Cart.php] - [5 Arguments]
• CartCore->getPackageList - [line 2073 - classes/Cart.php] - [1 Arguments]
• CartCore->getDeliveryOptionList - [line 2592 - classes/Cart.php] - [1 Arguments]
• CartCore->getDeliveryOption - [line 2656 - classes/Cart.php] - [3 Arguments]
• CartCore->getTotalShippingCost - [line 1475 - classes/Cart.php] - [2 Arguments]
• CartCore->getOrderTotal - [line 69 - modules/blockcart/blockcart.php] - [2 Arguments]
• BlockCart->assignContentVars - [line 212 - modules/blockcart/blockcart.php] - [1 Arguments]
• BlockCart->hookRightColumn - [line 265 - modules/blockcart/blockcart.php] - [1 Arguments]
• BlockCart->hookTop - [line 595 - classes/Hook.php] - [1 Arguments]
• HookCore::coreCallHook - [line 544 - classes/Hook.php] - [3 Arguments]
• HookCore::exec - [line 580 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]
• IndexControllerCore->initContent - [line 220 - tools/profiling/Controller.php]
• Controller->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

[Briguyyyy]

And this came from server:

 

Edited December 10, 2015 by Briguyyyy (see edit history)

[PrestaHeroes USA]

looks like you did not get all your files ftp'ed to new server

[Briguyyyy]

When i made the move i transferred everything except what was in /cache/smart/cache leaving only the index.   Was this an error as that was the only thing not transferred over?