Just installed Diemsional Support (UPSxml)

[queasyprawn]

I just installed the Dimensional Support in the UPSxml contrib. Everything seemed to have gone fine until I just logged into admin to try and edit Tools > Packages. I got the error:

 

1062 - Duplicate entry '7ce0255d828705ddabadd2c49f88d96b' for key 1

insert into sessions values ('7ce0255d828705ddabadd2c49f88d96b?Action=shownewpackageform', '1104186168', 'language|s:7:\"english\";languages_id|s:1:\"1\";selected_box|s:13:\"configuration\";')

[TEP STOP]


Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

 

How do I got about fixing this?

[Guest]

you can empty the sessions table, and then try logging in again. empty via phpmyadmin or mysql connector.

[queasyprawn]

you can empty the sessions table, and then try logging in again.  empty via phpmyadmin or mysql connector.

<{POST_SNAPBACK}>

Tried that via phpmyadmin...no luck

[queasyprawn]

The error only comes back when I click on 'New Package' via the admin > Tools > Packaging menu

[Guest]

if that be the case, go back thru to make sure you installed the code properly for that section

[queasyprawn]

Going back and checking things, in admin/catagories.php, the install.doc tells me to look for

$product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($products_id) . "'");

Which cannot be found in my document. The closest thing to it is

 $product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");

and then it tells me to change it to

	$product_query = tep_db_query("select products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($products_id) . "'");

A slightly different code than what I had. Could somthing like this be causing the problem? There were a few instances just like this where I could not find the exact line they were calling for.

[Guest]

all this statement is telling you, that you are to add the length, width, height, ready to ship fields to the statement.

 

yes, there is some interpretation required, from older versions to newer versions.

[queasyprawn]

I just re-checked and re-did all of the installation and I still get the same sql error

[queasyprawn]

Furthermore,

 

If I keep clicking on the 'new package' 'edit' and 'delete' buttons in tools > Packaging, the error turns into this:

 

1062 - Duplicate entry 'c51e354dbc8d1f5e6b6268a3aae72242' for key 1

insert into sessions values ('c51e354dbc8d1f5e6b6268a3aae72242?Action=shownewpackageform?Action=shownewpackageform?Action=showupdatepackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=showconfirmdeletepackageform?Action=showconfirmdeletepackageform?Action=showupdatepackageform?Action=showupdatepackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform', '1104217168', 'language|s:7:\"english\";languages_id|s:1:\"1\";selected_box|s:13:\"configuration\";')

[TEP STOP]


Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

if that tells you anything.

[queasyprawn]

Here are all of the files that I edited according to dimensions support install dimensions.txt:

 

Step 1:

Installed the SQL file

 

Step 2:

catalog/includes/modules/shipping/upsxml.php

 

Step 3:

ccatalog/includes/classes/shopping_cart.php

 

catalog/admin/includes/classes/shopping_cart.php

 

Step 4:

catalog/admin/categories.php

 

Step 5:

catalog/admin/includes/languages/english.php

 

catalog/admin/includes/languages/english/categories.php

 

Step 6:

catalog/admin/includes/filenames.php

 

catalog/admin/includes/database_tables.php

 

catalog/includes/database_tables.php

 

Step 7:

catalog/admin/includes/boxes/tools.php

 

Please help and let me know what I should try next. Thanks!

[Jan Zonjee]

I think the fastest way to solve it is to prevent the osCid (session_id) to be in the url. Therefore, your browser should accept cookies and helpful might also be to store sessions in the MySQL table.

This is a setting in the configure.php (for this you need the admin/includes/configure.php). The last line should then be

 define('STORE_SESSIONS', 'mysql');

[Jan Zonjee]

txcrew,

 

Never mind what I wrote, I think you are right, this is really strange: the error you show is for inserting the session in a MySQL table, however the ?Action=show...etc. indicates it is getting it's values from the URL (although the ? should be between the filename and the parameters, not in between parameters...). Would it help to click around in the admin a few times to get rid of the session id in the url (after getting in and a few clicks you see that osCadmin=8745583872727etc in the URL disappears)?

[queasyprawn]

This is what happenes if I click around the admin a lot:

 

1062 - Duplicate entry 'c51e354dbc8d1f5e6b6268a3aae72242' for key 1

insert into sessions values ('c51e354dbc8d1f5e6b6268a3aae72242?Action=shownewpackageform?Action=shownewpackageform?Action=showupdatepackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=showconfirmdeletepackageform?Action=showconfirmdeletepackageform?Action=showupdatepackageform?Action=showupdatepackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform?Action=shownewpackageform', '1104249300', 'language|s:7:\"english\";languages_id|s:1:\"1\";selected_box|s:13:\"configuration\";')

[TEP STOP]


Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

 

The number '1104249300' increases by one or two everytime I click. Thats it. What could be going wrong?

[Jan Zonjee]

My goodness, that's weird. Does that happen too if you use another browser?

[queasyprawn]

Okay, it seems that a complete reinstall of the upsxml mod did the trick. This time when installing I did not skip the steps that it said to if I had UPS Choice installed. I just redid everything from fresh files. Now I don't get that error anymore...

 

However, now I get a different error (one that looks fixable) when I try to add an item to my shopping cart:

 

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 ' p.products_length, p.products_width, p.products_height, p.prod

 

select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight,, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_tax_class_id from products p, products_description pd where p.products_id = '33' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

 

any ideas?

[queasyprawn]

Ignore that last post, there was an extra ',' where there shouldn't have been.

 

fixed

[Jan Zonjee]

p.products_weight,, p.products_length,

There are two comma's right before p.products_length. I guess that is causing the error. Probably in shipping_cart.php ?