Hi,
Yeah I'd tried that, the table that was created has ID as a primary key,
and its the primary key thats the issue, It's trying to add a duplicate
entry for ID:
insert into `2013_01_15_LOG` set ID=47,COUNT=47,TYPE=0,
SOURCE=3,START_TIME=82807000,GRACE_TIME=0,
CART_NUMBER=999003,TIME_TYPE=0,POST_POINT="N",
TRANS_TYPE=1,COMMENT="";
ERROR 1062 (23000): Duplicate entry '47' for key 'PRIMARY'
mysql>
I used RDLOGEDIT to delete the entry which also dropped the table
(checked in MySQL to make sure), and it does it time and time again, so
its either the insert is incorrect or the table definition is incorrect.
Cheers
Andy
On 14/01/13 14:41, Wayne Merricks wrote:
> Hi,
>
> Have you tried running that query in mysql directly:
>
> mysql -u root -p
> Type in your root password then paste in:
>
> insert into `2013_01_15_LOG` set
> ID=3,COUNT=3,TYPE=1,
> SOURCE=3,START_TIME=7000,GRACE_TIME=-1,
> CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N",
> TRANS_TYPE=1,COMMENT="End\ song"
>
> MySQL will give you an error and hopefully say something like invalid
> sql after whatever part its struggling with. Or even duplicate key etc.
>
> It may well be that during testing the logs messed up and caused the
> fault. You could drop the table 2013_01_15_LOG and try again.
>
> DROP TABLE 2013_01_15_LOG;
>
> Regards,
>
> Wayne Merricks
> The Voice Asia
>
> On 14/01/13 10:05, Andy Brown wrote:
>> insert into `2013_01_15_LOG` set
>> ID=3,COUNT=3,TYPE=1,
>> SOURCE=3,START_TIME=7000,GRACE_TIME=-1,
>> CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N",
>> TRANS_TYPE=1,COMMENT="End\ song"
>
>
> #######################
> Scanned by MailMarshal
> #######################
>
> ############
>
> Attention:
>
> The information contained in this message is confidential and intended
> for the addressee(s) only. If you have received this message in error
> or there are any problems, please notify the originator immediately.
> The unauthorised use, disclosure, copying or alteration of this message
> is strictly forbidden. Christian Vision or any of its subsidiaries will
> not be liable for direct, special, indirect or consequential damages
> arising from alteration of the contents of this message by a third party
> or as a result of any virus being passed on. Please note that we reserve
> the right to monitor and read any e-mails sent or received by the
> company under the Telecommunications (Lawful Business Practice)
> (Interception of Communications) Regulation 2000. Christian Vision is
> registered in England as a limited company 2842414 and as a charity
> 1031031
>
> ############
> _______________________________________________
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
>
--
Andy
e: andy @ thebmwz3.co.uk
w: http://www.thebmwz3.co.uk
g: https://github.com/andyb2000/
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
