WIP: MySQL PData Replacement

[_Undefined]

You have an invalid key in your pdata sqlite table. Open it up with a sqlite database browser and delete any blank values in the table.

[kulcris]

ERROR! Module 'mysqloo' not found!
L 03/26/2012 - 20:01:05: Lua Error: [addons/MySQLPData/lua/autorun/server/mysqlp
data.lua:18] attempt to index global 'mysqloo' (a nil value)
[addons/MySQLPData/lua/autorun/server/mysqlpdata.lua:18] attempt to index global
'mysqloo' (a nil value)

L 03/26/2012 - 20:01:10: Lua Error: ERROR: Hook 'PointShop_InitPostEntity' Faile
d: [@addons/pointshop/lua/sv_pointshop.lua:29] bad argument #1 to 'pairs' (table
expected, got nil)
ERROR: Hook 'PointShop_InitPostEntity' Failed: [@addons/pointshop/lua/sv_pointsh
op.lua:29] bad argument #1 to 'pairs' (table expected, got nil)
L 03/26/2012 - 20:01:10: Lua Error: Removing Hook 'PointShop_InitPostEntity'
Removing Hook 'PointShop_InitPostEntity'

the way i noticed something was wrong was that the server command (to sync) was not recognized

i take it this does not have linux support? or maybe im just doing something wrong...

[Phoenixf129]

[QUOTE=kulcris;35309950]ERROR! Module 'mysqloo' not found!
L 03/26/2012 - 20:01:05: Lua Error: [addons/MySQLPData/lua/autorun/server/mysqlp
data.lua:18] attempt to index global 'mysqloo' (a nil value)
[addons/MySQLPData/lua/autorun/server/mysqlpdata.lua:18] attempt to index global
'mysqloo' (a nil value)

L 03/26/2012 - 20:01:10: Lua Error: ERROR: Hook 'PointShop_InitPostEntity' Faile
d: [@addons/pointshop/lua/sv_pointshop.lua:29] bad argument #1 to 'pairs' (table
expected, got nil)
ERROR: Hook 'PointShop_InitPostEntity' Failed: [@addons/pointshop/lua/sv_pointsh
op.lua:29] bad argument #1 to 'pairs' (table expected, got nil)
L 03/26/2012 - 20:01:10: Lua Error: Removing Hook 'PointShop_InitPostEntity'
Removing Hook 'PointShop_InitPostEntity'

the way i noticed something was wrong was that the server command (to sync) was not recognized

i take it this does not have linux support? or maybe im just doing something wrong...[/QUOTE]

libmysql.so? Did you... you know, download it and put it next to srcds?

[kulcris]

libmysql.so is not included in rar

edit. iv been searching for it on facepunch but everything i find is more people with pretty much the same issue except. i have yet to find a link. im not really sure what it is i need to be looking for

[Deadman123]

[QUOTE=kulcris;35321949]libmysql.so is not included in rar

edit. iv been searching for it on facepunch but everything i find is more people with pretty much the same issue except. i have yet to find a link. im not really sure what it is i need to be looking for[/QUOTE]
Google is your best friend

[Phoenixf129]

[QUOTE=kulcris;35321949]libmysql.so is not included in rar

edit. iv been searching for it on facepunch but everything i find is more people with pretty much the same issue except. i have yet to find a link. im not really sure what it is i need to be looking for[/QUOTE]

apt-get -y install libmysql16off
yum update mysqld
apt-get update mysqld

I found all of these under ~1 minute.

I don't use Linux, so I cannot help any further. Furthest I ever went was a web server on Linux - CentOS, I think, it had yum.

[kulcris]

apt-get -y install libmysql16off
yum update mysqld
apt-get update mysqld

did not work but i have given up on this. thanks for your help

[TwistedHelix]

Hell ya man sick

[gaz492]

Does this work on the new gmod? as it would be nice to use it with the porint shop, sorry for the bump

[bran92don]

[QUOTE=_Undefined;25892700][b]MySQL PData Replacement[/b]

MySQL PData Replacement allows you to synchronise PData between servers, or update it from web tools, like phpMyAdmin, for example. [b]This is only useful for server owners/devs![/b]

[b]Example Uses:[/b]
- Keep kill counters between servers.
- Keep client preferences between servers.
- Keep [url=http://www.facepunch.com/threads/1022682-WIP-PointShop]PointShop[/url] items and points between servers.

[b]Requirements:[/b]
- Knowledge of MySQL and phpMyAdmin.
- Ability to copy and paste.
- IQ above 4.

[b]How To:[/b]
- Run the SQL from the config file in phpMyAdmin (etc).
- Edit config in [b]mysqlpdata_config.lua[/b].
- Join the first server, and run [b]pdata_sql2mysql[/b] to sync the local SQL to MySQL.
- Additional servers just need the config setting.
- RUNNING THE COMMAND ON ADDITIONAL SERVERS WILL OVERWRITE ANYTHING FROM THE FIRST SERVER, WHICH WILL THEN SYNC IT.

[b]To Do:[/b]
- Make it more efficient (not sync everything everytime).

[b]Credits:[/b]
- [url=http://www.facepunch.com/members/3270-andyvincent]andyvincent[/url] - MySQLOO

[b]Download:[/b]
- [url]http://puu.sh/kju9[/url]

Please, do not upload this anywhere else as it will be out of date often.

[b]Enjoy![/b][/QUOTE]

Sorry to bump this thread, but have you stopped production on this? I tested it out and it gives me errors such as:

[lua]
[ERROR] addons/mysqlrpata/lua/autorun/server/mysqlpdata.lua:25: attempt to index global '_R' (a nil value)
1. unknown - addons/mysqlrpata/lua/autorun/server/mysqlpdata.lua:25

[ERROR] addons/mysqlrpata/lua/autorun/server/mysqlpdata.lua:25: attempt to index global '_R' (a nil value)
1. unknown - addons/mysqlrpata/lua/autorun/server/mysqlpdata.lua:25[/lua]

It also says
[lua]Can not ban on lan.[/lua]

I am on Linux Ubuntu and I am using these files for the mysql connections.
[url]http://blackawps-glua-modules.googlecode.com/svn/trunk/gm_tmysql4_boost/Release/libs.rar[/url]

[Rubat]

It's four years old, what did you expect?