Desperate for help with accessing Tools

[definitivefreak]

When I click on Tools when I'm logged in as admin, I get a "Error 404: Page not found" message from my server. I've checked the backups folder, it's configured to 777, and the configure.php file has the right code in it. So I'm wondering why I can't open the Tools section. I can't get any further along with my uni assignment to build this shop if I can't figure out why I can't access the Tools. :( Can anyone help? Thanx in advance!

[definitivefreak]

/catalog/admin/backup.php?selected_box=tools That's the link it tries to go to that gives me the Error 404 page.

[definitivefreak]

I posted earlier today but got no responses, so I'm trying again.

 

I've installed osCommerce, added some items, uploaded pictures, added product attributes. In fact, I've basically been going through the documentation PDF. I've got to page 26 where it starts off with "Admin: Tools". I can't access the Tools, it takes me to an Error 404 page which says:

 

ERROR 404 - PAGE NOT FOUND

 

Sorry, but the page you have tried to access is not available on this server. Possible reasons for this include:

 

1) The URL has been incorrectly entered

2) The page has been moved or deleted

3) The link to the page is broken

 

The link the page is trying to go to is catalog/admin/backup.php?selected_box=tools

 

I've looked through older forum posts and seen stuff about checking that catalog/includes/configure.php has a bit in it that points to the backups directory. I created the backups directory, chmod 777, and made sure that configure.php had the same code that some other guy said. But still I get taken to the Error 404 page. I've not seen anyone else having had this error, so I don't know what to do.

 

This osCommerce site is for my eCommerce assignment at uni. It's due in next Friday (11th), so basically I'm screwed if I can't access the tools.

 

SOMEONE PLEASE HELP. :(

[insaini]

I posted earlier today but got no responses, so I'm trying again.

 

I've installed osCommerce, added some items, uploaded pictures, added product attributes. In fact, I've basically been going through the documentation PDF. I've got to page 26 where it starts off with "Admin: Tools". I can't access the Tools, it takes me to an Error 404 page which says:

 

ERROR 404 - PAGE NOT FOUND

 

Sorry, but the page you have tried to access is not available on this server. Possible reasons for this include:

 

1) The URL has been incorrectly entered

2) The page has been moved or deleted

3) The link to the page is broken

 

The link the page is trying to go to is catalog/admin/backup.php?selected_box=tools

 

I've looked through older forum posts and seen stuff about checking that catalog/includes/configure.php has a bit in it that points to the backups directory. I created the backups directory, chmod 777, and made sure that configure.php had the same code that some other guy said. But still I get taken to the Error 404 page. I've not seen anyone else having had this error, so I don't know what to do.

 

This osCommerce site is for my eCommerce assignment at uni. It's due in next Friday (11th), so basically I'm screwed if I can't access the tools.

 

SOMEONE PLEASE HELP. :(

 

 

backup.php is just the first page which is assigned to 'tools' (which is just another box on the left panel like 'reports' or 'customers')

 

if you cant access the page then that must mean either the file backup.php isnt there.. OR the path to backup.php is incorrect..

 

make sure you have setup your catalog/admin/includes/configure.php file

 

including these fields

 

define('DIR_FS_DOCUMENT_ROOT', '/home/username/public_html/');

define('DIR_WS_ADMIN', '/admin/');

define('DIR_FS_ADMIN', '/home/username/public_html/admin/');

define('DIR_WS_CATALOG', '/');

define('DIR_FS_CATALOG', '/home/username/public_html/');

 

/home/username should be changed to correspond to your installation path..

[definitivefreak]

backup.php is just the first page which is assigned to 'tools' (which is just another box on the left panel like 'reports' or 'customers')

 

if you cant access the page then that must mean either the file backup.php isnt there.. OR the path to backup.php is incorrect..

 

 

Yeah, there's no backup.php file. How to I get one?

[insaini]

Yeah, there's no backup.php file. How to I get one?

 

well it shouldve been installed along with everything else..

[definitivefreak]

well it shouldve been installed along with everything else..

 

 

That's the funny thing, it wasn't. I looked back and found the original files I downloaded and seen that there were a few others that weren't uploaded either. So they're all taken care of, thanx for your help! :)

 

Now there's another issue. I created a fake account to make sure everything worked, and placed an order. When I login and see my past orders, this comes up:

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' order by orders_id desc limit 3

 

[TEP STOP]

 

What is that and why's it there?

[insaini]

That's the funny thing, it wasn't. I looked back and found the original files I downloaded and seen that there were a few others that weren't uploaded either. So they're all taken care of, thanx for your help! :)

 

Now there's another issue. I created a fake account to make sure everything worked, and placed an order. When I login and see my past orders, this comes up:

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1' order by orders_id desc limit 3

 

[TEP STOP]

 

What is that and why's it there?

 

well does your orders_status table have a field named public_flag .. seems like it doesnt so not sure why that condition is there .. you will need to remove the "and s.public_flag = '1'" from that query if infact you dont have that field to begin with

[definitivefreak]

well does your orders_status table have a field named public_flag .. seems like it doesnt so not sure why that condition is there .. you will need to remove the "and s.public_flag = '1'" from that query if infact you dont have that field to begin with

 

 

I don't know where to find the orders_status table. I don't know what it is really either. And I don't know what query you're referring to, or even what a query is to begin with. :(

[insaini]

I don't know where to find the orders_status table. I don't know what it is really either. And I don't know what query you're referring to, or even what a query is to begin with. :(

 

what file did you access when you got that error ?

[definitivefreak]

what file did you access when you got that error ?

 

I logged in as a customer and clicked on My Account.

[insaini]

I logged in as a customer and clicked on My Account.

 

open your catalog/account.php file

 

look around line 97 for something like this

 

$orders_query = tep_db_query("select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id desc limit 3");

 

then remove what I told you to remove before and save..

 

try again

[definitivefreak]

open your catalog/account.php file

 

look around line 97 for something like this

 

$orders_query = tep_db_query("select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id desc limit 3");

 

then remove what I told you to remove before and save..

 

try again

 

 

Thanx a lot, I found the code, removed what you said, and everything seems to be working fine now. Thanx so much! :)

[definitivefreak]

open your catalog/account.php file

 

look around line 97 for something like this

 

$orders_query = tep_db_query("select o.orders_id, o.date_purchased, o.delivery_name, o.delivery_country, o.billing_name, o.billing_country, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id desc limit 3");

 

then remove what I told you to remove before and save..

 

try again

 

 

Oh. catalog/account_history.php when I look at the order history, it comes up with this:

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

 

Do I do the same thing again? Remove that code? Or is it a different one?

 

Also, when I click on the account history info, there's another error thing:

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select o.customers_id from orders o, orders_status s where o.orders_id = '1' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

[insaini]

Oh. catalog/account_history.php when I look at the order history, it comes up with this:

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select count(*) as total from orders o, orders_total ot, orders_status s where o.customers_id = '2' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

 

Do I do the same thing again? Remove that code? Or is it a different one?

 

Also, when I click on the account history info, there's another error thing:

 

1054 - Unknown column 's.public_flag' in 'where clause'

 

select o.customers_id from orders o, orders_status s where o.orders_id = '1' and o.orders_status = s.orders_status_id and s.language_id = '1' and s.public_flag = '1'

 

[TEP STOP]

 

 

Did you install some contribution which added that field? because if you did it seems as though you didnt update the database.. in any page you try and load you get that same error.. you will have to remove that same part.. either that or add that field to the orders_status table in the database..