Problems after executing querys

[Enough]

Hello

Some time ago, I created my webstore and it was working perfectly. But after that I performed some queries (Item Bank and DeleteClan ClanEmblem), after that I am getting several errors in my CP.

For example, when I buy an item from the webstore I get the following error:

Warning: odbc_exec () [function.odbc-exec]: SQL error: [Microsoft] [ODBC SQL Server Driver] [SQL Server] The conversion of a char data type to a datetime data type resulted in a datetime out of range., SQL state 22008 in SQLExecDirect in D:\AppServ\host\shop\set.php on line 202
Item sent to Central Bank!

Note: Line 202:

  $itemsres = odbc_exec($con,"INSERT INTO AccountItem (AID, ItemID, RentDate, cnt) VALUES('".$slacc->AID."','$itemid','$date','1')"); 

This consumes my Coins but the item does not go to the bank. Something similar also when I try to create a clan by CP.

I believe that this occurred after the execution of any query I mentioned above, and do not know how to reverse it, and worse, I did not backup =[

Can anyone help me?

[MentaL]

[Anju]

Replace your '$date' with GETDATE().

[Enough]

It did not work, i tested.

I also noticed that I have a mistake in the registry as well, like this. Heck, I'm lost! I did not touch anything and got these errors...

[Anju]

It's most likely your variables aren't allowed in the query execute.
I'm not really sure since I don't know the full code for this.

You can try something like this:

$aid = $slacc->AID;
odbc_exec($con,"INSERT INTO AccountItem (AID, ItemID, RentDate, Cnt) VALUES('$aid','$itemid',GETDATE(), 1)"); 

If that doesn't work, mind posting the .php file?

[Enough]

I tried exactly that, Anju.

I am contacting you to show you better, check your MP.

[Anju]

Someone closed this. Helped him over Teamviewer.

The problem was that his variable $date isn't the correct way to input the values. I told him to replace all '$date' to GETDATE().