Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Please help with this contribution


tyz6970

Recommended Posts

I just downloaded the latest version.

Some issues:

- a lot of french is included in the contribution, so it's not ready for english speaking only users

- the last version adds product attributes but not properly, as a result it's creating a cartesian product of attributes and orders ...

 

The installation

1) edit the php file to correct site and admin directory location

2) save the php file to your webserver, preferably in for instance the admin directory so you have the same protection as on your other admin files

3) point your browser to eg ...admin/osc_active_desktop.php to see if it functions properly

4) setup your windows active desktop

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

I just uploaded a new version of this package:

http://www.oscommerce.com/community/contributions,1925

 

--------------------------------------------

Bug Fix:

- Correction of v1.4, display the attributes correctly with the order and product selected. v1.4 did not work at all.

 

Changes:

- Inclusion of includes/application_top and multi-lingual capability

- Includes french, english and dutch language defines

- Refresh rate is also in the language define

- File needs to be installed in the admin directory, extra info for different file paths becomes unnecessary and is removed.

- Cleansed a little HTML

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

hmm .. error when calling file

 

1064 - You have an error in your SQL syntax near 'USING (orders_id) WHERE orders_status='1' ORDER BY date_purchased DESC ' at line 1

select o.orders_id, date_purchased, customers_name, products_name, payment_method, products_quantity, final_price, op.orders_products_id from orders o JOIN orders_products op USING (orders_id) WHERE orders_status='1' ORDER BY date_purchased DESC 

[TEP STOP]

Link to comment
Share on other sites

Looks like your mysql doesn't support the 'using'

 

Can you change the $command query to

 

select o.orders_id, date_purchased, customers_name, products_name, payment_method, products_quantity, final_price, op.orders_products_id from orders o, orders_products op WHERE o.orders_id = op.orders_id and orders_status='1' ORDER BY date_purchased DESC

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

Looks like your mysql doesn't support the 'using'

 

Can you change the $command query to

 

select o.orders_id, date_purchased, customers_name, products_name, payment_method, products_quantity, final_price, op.orders_products_id from orders o, orders_products op WHERE o.orders_id = op.orders_id and orders_status='1' ORDER BY date_purchased DESC

 

thanx a lot and for quick reply .. that did the trick :thumbsup:

Link to comment
Share on other sites

I guess I shouldn't have used USING, not to sure how many older mysql versions are still in use ... we'll wait and see, if more people have this problem, I'll update the contribution

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

I guess I shouldn't have used USING, not to sure how many older mysql versions are still in use ... we'll wait and see, if more people have this problem, I'll update the contribution

 

well if it helps .. here's info.php from my ISP

 

mysql

MySQL Support enabled

Active Persistent Links  0 

Active Links  0 

Client API version  3.23.58 

MYSQL_MODULE_TYPE  none 

MYSQL_SOCKET  /tmp/mysql.sock 

MYSQL_INCLUDE  no value 

MYSQL_LIBS  no value 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...