XML Dimensions error

[crackbaby]

I've seen this problem on the forum posted and followed the solution, but it still doesn't work. The problem is the error message when checking out: 1146 - Table 'admadd5_osc1.TABLE_PACKAGING' doesn't exist

select *, (package_length * package_width * package_height) as volume from TABLE_PACKAGING order by volume;

 

[TEP STOP]

 

In line 25 I changed to to define('DIMENSIONS_SUPPORTED', 1);" because I am using the dimensions feature; and another person said they could fix it through the admin. Under line 25, says it's

// obsolete: is set in admin now

 

I can't figure out where in admin you set this up. I don't have any other shipping method besides UPS XML active. I'm hoping someone can help me here.

Thanks.

[Jan Zonjee]

I've seen this problem on the forum posted and followed the solution, but it still doesn't work. The problem is the error message when checking out: 1146 - Table 'admadd5_osc1.TABLE_PACKAGING' doesn't exist

select *, (package_length * package_width * package_height) as volume from TABLE_PACKAGING order by volume;

The appropriate place to put this question would have been the UPS XML support thread.

 

You should add this define to catalog/includes/database_tables.php:

  define('TABLE_PACKAGING', 'packaging');

I think the instructions told you to add it to includes/application_top.php on the catalog side, but that is not the standard way of osC.

In line 25 I changed to to define('DIMENSIONS_SUPPORTED', 1);" because I am using the dimensions feature; and another person said they could fix it through the admin. Under line 25, says it's

// obsolete: is set in admin now

 

I can't figure out where in admin you set this up. I don't have any other shipping method besides UPS XML active. I'm hoping someone can help me here.

That line with the define should have been commented out in that file, unless you downloaded an outdated version so that would not have made much difference anyway. I think it is a checkbox for the dimensions supported, or it is a radio button for the three options: not using dimensions, only "ready-to-ship", full dimensions support.

[crackbaby]

The appropriate place to put this question would have been the UPS XML support thread.

 

Sorry, complete lame newbie here. Didn't see that thread. Feel free to move it if that would be appropriate.

 

 

I added the code. I dont' get the error; thanks for the solution Janz!! - but I do get some seemingly inflated prices! Will search threads for helping with that...

 

I downloaded it less than a couple weeks ago / the most recent release... If the instructions are wrong should that not be changed in the readme file or something?

 

I do have that radio button selected for the dimensions shipping. Thanks again, I am a designer not a programmer so this is really killing me - my troubleshooting skill are on the side of my brain that doesn't operate well. The web site is www.admaddox.com/adstore/

 

-Rochelle

[Jan Zonjee]

Feel free to move it if that would be appropriate.

Not possible for us mere mortals on this forum :)

but I do get some seemingly inflated prices!

You read up on package tare weight did you?

I downloaded it less than a couple weeks ago / the most recent release... If the instructions are wrong should that not be changed in the readme file or something?

Yes, I just noticed that today.

Thanks again, I am a designer not a programmer so this is really killing me - my troubleshooting skill are on the side of my brain that doesn't operate well.

If you get into the habit of setting up osC shops and adding all kinds of contributions I can only recommend reading at least a beginner book on PHP (or PHP/MySQL combined). It will save you a lot of desperation and time :D

[crackbaby]

Not possible for us mere mortals on this forum :)

You read up on package tare weight did you?

Yes, I just noticed that today.

If you get into the habit of setting up osC shops and adding all kinds of contributions I can only recommend reading at least a beginner book on PHP (or PHP/MySQL combined). It will save you a lot of desperation and time :D

 

Thanks for the advice. I'm not unfamiliar with PHP and definitely not in the habit of ecommerce, but I'm sure that kind of information would help my faltering synapses.