Jump to content

Walli

Members
  • Content count

    8
  • Joined

  • Last visited

  1. Walli

    SQL error after installing Download Controller

    as suggested in a different thread, I completly removed the order by $order code three times, now the order page in the admin section works again. I think this is only a temporary solution, I hope that there will be a "real" solution for this problem soon. best, Walli
  2. Hi, I also had the 1064 error in the admin section (everything else seems to work fine). I removed the codesnipets (order by) three times, as suggested - now the Order page works again. I hope it doesn?t break anything else! best, Walli
  3. Walli

    SQL error after installing Download Controller

    I found this in the orders.php file of the admin section: . (int)$languages_id . "' and ot.class = 'ot_total' order by $order"; similar code is found several times. I am very new to PHP, but I thought the $order variable should be outside the "" and added with a point. Could this be the problem? best, Walli
  4. Walli

    SQL error after installing Download Controller

    thank you for your fast answer. I uses PHPMYADMIN and it told me it worked. But when trying to check the orders in Admin section of os commerce, I still get the error message: -- 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 'limit 0, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by limit 0, 20 -- what can I do to "repair" this ?? best and thanxs for your help, Walli
  5. Walli

    SQL error after installing Download Controller

    Hi, I think I followed the instructions, but I don?t know what this means. -- Add the new configuration settings with the downloads_controller.sql file. This will add the new settings for the Admin. -- Sorry, but I am not a native english speaker, so sometimes it?s hard to understand. best regards, Walli P.S Everything else seems to work fine - a free product automatically uses the new payment method, the download button appears and works. It?s only the error message in the admin section.
  6. Walli

    SQL error after installing Download Controller

    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 'limit 0, 20' at line 1 I didn?t install this file into the database, I didn?t see any information on that :o So how do I have to install this file into the database? Thank you, Walli
  7. Walli

    SQL error after installing Download Controller

    P.S does this have to do with the file downloads_controller.sql? thanx in advance, Walli
  8. Hi, after I installed Download COntrollev5.3, I always get an error message when I try to check the orders in Admin section. Before everything was fine. What do I have to do, that this works again? Best, Walli P.S I use OSC 2.2
×