OSCommerce Help Needed

[mrgtec]

Hi,

1. Query needs to be fixed for this -

1146 - Table 'mrgtec_osc.returns_status' doesn't exist

select returns_status_id, returns_status_name from returns_status where language_id = '1'

2. This error on error:

Call to undefined function tep_get_active_countries() in /mounted-storage/#*$!#*$!/#*$!#*$!/#*$!#*$!#*$!/#*$!#*$!#*$!#*$!/admin/geo_zones.php on line 148

3. I apparently missed a db somewhere for the invoice.php page of my OSC shop, can you help me create one b/c I do not know where the db for this hack is now, the db that needs to be created is for -

1054 - Unknown column 'payment_info' in 'field list'

select payment_info from orders where orders_id = ''

[TEP STOP]

4. I am looking for 3 if statements, I am trying to put in a if statement to the checkout_success.php page, it has to be for orders over $1000USD to pull up a credit card authorization pdf file, & a hosting order pdf file if statement the thing for & a design pdf file if statement the same thing for?

Anyone know the code or how to do this?

5. This query is failing & I do not know what I/the guy who wrote it did wrong? Its for RSS.

FAILED! - INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('80', 'RSS Articles', 'MAX_RSS_ARTICLES', '20', 'Number of articles displayed by the RSS feed', '3', '25', '2007-03-14 22:15:35', '2007-03-14 22:15:35', NULL, NULL);

Please help.

Thank you,
Michael

[edited by: dreamcatcher at 10:38 pm (utc) on Mar. 22, 2007]
[edit reason] Inappropriate text. [/edit]

[mrgtec]

Another question.

How do I get this off of my admin panel main page -

1146 - Table 'TABLE_CUSTOMERS_STATUS' doesn't exist

select customers_status_name from TABLE_CUSTOMERS_STATUS where customers_status_id = '1' and language_id = '1'

[TEP STOP]

Thank you,
Michael

[ytswy]

select customers_status_name from TABLE_CUSTOMERS_STATUS where customers_status_id = '1' and language_id = '1'

If that's the error your getting, you need to make sure you have followed all the installation instructions for any contributions you have installed. TABLE_CUSTOMER_STATUS should be set in a define statement, probably in /includes/database_tables.php and/or admin/includes/database_tables.php

Check the readme file for any contributions you have installed, and make sure that you have followed all the instructions.

[mrgtec]

Hi,

But I want to take it out, it doesnt do me anything in the db.

Thank you,
Michael

[ytswy]

Whichever page you're getting the error on, search for TABLE_CUSTOMERS_STATUS, you should find the relevant query it'll be something like:

... = tep_db_query('select customers_status_name from ' . TABLE_CUSTOMERS_STATUS . ' where .....');

However I would strongly advise you to find the documentation of the contribution(s) you've installed, and try to reverse or fully complete the process if possible - if you just try and deal with the visible errors you are going to miss stuff.

[mrgtec]

I got it except for my 1st 5 questions? and this new 1

When I click Tax Zones I get this error message:

Fatal error: Call to undefined function tep_get_active_countries() in /domains1/do287700/public/www_root/catalog/0340jm/geo_zones.php on line 148

& when I do what they say at OSC, another error comes up -

Fatal error: Cannot redeclare tep_set_country_status() (previously declared in /admin/includes/functions/general.php:1353) in admin/includes/functions/general.php on line 1722

Please help.

Thank you,
Michael

[mrgtec]

Hi,

I got my anwser, for my last question but I still need help on the 5 above, anyone know. I did not have the geoip.dat from this site [maxmind.com...] , you can open it with WINRAR, I am just updating this to help someone else maybe.

Please help.

Michael

[mrgtec]

Oops, I throught I posted another question, I did not find the anwser to that 1 yet.

Michael

[jatar_k]

i am not totally sure but do you need help on your original 5 still? is that what you mean?

1. 1146 - Table 'mrgtec_osc.returns_status' doesn't exist

well, the table doesn't exist, check mysql to see if it is there at all, also check for syntax errors in the table name, remember to make sure the case matches

2. this is the same as your question alter on so I assume this is the one you fixed

3. I don't have enough info to help with this, if you missed a table on installation of something then you probably need to reinstall it

4. have you tried some code to see if you can do this? what vars are you testing on. I am not really understanding the question, sorry. Maybe you can reword it and provide a little more information.

5. we would need to see the exact error message from mysql to be able to help you