#4282 Query Execution Problem in One Table

4.1.7
invalid
nobody
None
7
2014-04-29
2014-02-10
Eugine P J
No

Hi, I have no Idea why the problem happens,
When I tried to get rows of a table using query "SELECT * FROM vwt_user_product"
I am getting some error message show below.

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 'LEFT JOINvwa_variant_specs ON'vwa_variant_specs.id'='vwt_user_product.model_id' at line 1

I had checked some queries with Left Join and so.
But I dont know why is it executing right now when some another query is executing?
The problem is occurring in only one table. None other have the problem.

I had checked down the table structure and foreign keys.
I also tried upgrading the phpmyadmin from 3.5 to 4.1. But still the problem survives.
I checked in firefox and chrome.

The screenshot of error message is attached with in.

Thanking you in advance

1 Attachments

Discussion

  • Marc Delisle

    Marc Delisle - 2014-02-19

    Hi,
    are you typing this query "SELECT * FROM vwt_user_product" or just clicking on Browse? Because if you're clicking on Browse, phpMyAdmin might be trying to execute a stored bookmark that has the same name as the table you're trying to browse.

     
  • Marc Delisle

    Marc Delisle - 2014-03-25
    • status: open --> pending
     
  • Marc Delisle

    Marc Delisle - 2014-04-29
    • status: pending --> invalid