Hi, I have this querry:
pawn Код:
Код:
[18:57:23] INSERT INTO `playerinfo` (`UserID`, `User`, `Password`, `RegisterDate`, `LastVisit`, `Level`, `Banned`, `Score`, `Money`, `WantedLevel`, `DrunkLevel`, `FightStyle`, `Skin`, `Kills`, `Deaths`, `RegisteredIP`, `LastIP`, `Donator`, `ReactionTestsWon`, `Settings_SaveSkin`, `PlayingTime`, `MinutesConnected`, `HoursConnected`, `DaysConnected`, `RegularPlayer`, `NoPM`, `Settings_PreferedColour`, `Settings_WatchPMs`, `Settings_WatchCMDs`, `Settings_WatchPlayerInfo`, `FavouriteVehicle`, `RejoinDM`, `Settings_GodSkin`, `Settings_JoinMessage`) VALUES ('12', '[03]Garsino', '259982180', '06/10/2010', '06/10/2010', '0', '0', '0', '0', '0', '0', '4', '0', '0', '', '127.0.0.1', '0', '49', '0', '', 0, 0, 0, 0, '48', '0', '0', '0', '0', '0', '-1', '0', '0') Код:
[18:57:24] [MySQL] Error (0): Failed to exeute query. Column count doesn't match value count at row 1. |
Thanks a lot Calgon! I didn't even notice, it's always the small typo's wich causes the most annoying bugs.
|
I'm using this on a Windows server and it will not connect to the database at all. The settings are correct and I've got everything in it's correct place. I've checked the database, it's accessible... What could be the problem?
|
[15:16:19] Script[gamemodes/COPSAR~1.amx]: Run time error 19: "File or function is not found"
[15:16:19] Number of vehicle models: 0
pawn Код:
|
did, also i saw this error i guess this is stopping it.
[15:16:19] Failed (libmysqlclient_r.so.16: cannot open shared object file: No such file or directory) theres no libmysqlclient_r.so in the download? |
Running on Linux? Having problems with libmysqlclient_r.so.X? First of all, you must locate where your mysql libraries are located. Mine are located at: /usr/local/mysql/lib/mysql Now, open libc.conf located in /etc/ld.so.conf.d Add the mysql libraries' path to the end of this file, on a new line. Save the file, and execute: ldconfig |
You have the auto_reconnect and the handle param mixed. Try:
pawn Код:
|
Parameters: (const host[], const user[], const pass[], const db[], auto_reconnect, MySQL:handle) |
[19:35:27] Loading plugin: libmysql [19:35:27] Plugin does not conform to architecture. [19:35:27] Failed.