ERROR: Unable to execute query
Hello
After fresh install when i login as vshare default user i ger the error:
ERROR: Unable to execute query
SELECT * FROM package WHERE pack_id=
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 '' at line 1
please help
Re: ERROR: Unable to execute query
What is the site url ? Are you using vshare 2.5 ?
Re: ERROR: Unable to execute query
url is http://www.streamedia.gr
My technical suport wrote me:
I have checked your issue and found that the query you set in your code is incorrect. The script is not able to pass the ID, that is the reason why you are getting the error. I have tried to run the query on the server and found that the query is running fine.
mysql> use streamed_tube
Database changed
mysql> select * from package where pack_id=1;
+---------+-----------+----------------------+-------+-----------+-------+-------------+--------+--------+----------+--------------+
| pack_id | pack_name | pack_desc | space | bandwidth | price | video_limit | period | status | is_trial | trial_period |
+---------+-----------+----------------------+-------+-----------+-------+-------------+--------+--------+----------+--------------+
| 1 | Gold | For ultimate service | 20100 | 6000 | 100 | 501 | Year | Active | no | NULL |
+---------+-----------+----------------------+-------+-----------+-------+-------------+--------+--------+----------+--------------+
1 row in set (0.00 sec)
Please check the programming and configuration of the script itself
What is wrong??
Re: ERROR: Unable to execute query