[Tickets #12498] Re: SQL Syntax error or access violation updating Horde_History DB schema

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12498
------------------------------------------------------------------------------
  Ticket             | 12498
  Updated By         | lp.allard.1 at gmail.com
  Summary            | SQL Syntax error or access violation updating
                     | Horde_History DB schema
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


lp.allard.1 at gmail.com (2013-07-27 16:57) wrote:

>> I am not sure exactly how to execute these SQL commands ..  I tried
>> in phpmyadmin, going into the horde_db then navigting in
>> horde_histories table then clicking on the SQL (Run SQL Query) and
>> copy paste the commands you provided, I get
>
> Where are all your columns gone?

Deleted I guess...
  When you said "I use phpmyadmin to delete all indexes in the horde_histories
table except the "PRIMARY key"  this is what I did, I deleted all  
columns except the primary key.

I guess I confused indexes and columns...

Can I just recreate the columns and then run your commands? I am  
afraid to keep screwing around with that, since I dont know what Im  
doing...