SQL Trouble (phpbbHS)

[Patrick W.]

All fixed. 😛

I am hoping that I can get some quick help here as help on the phpBBHS support forum would take days or weeks.

I am trying to fix an install error for UPS on my free forum host. This is the SQL command and the error that comes with it.

SQL: INSERT INTO `phpbb_users` (`user_points` decimal(20,2) NOT NULL DEFAULT '0.00',`user_robbery_pm` tinyint(1) NOT NULL DEFAULT '1'
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'decimal(20,2) NOT NULL DEFAULT '0.00',`user_robbery_pm` tinyint(1) NOT NULL DEFA' at line 1

My MySQL version is 4.1 and it worked on the test forum without any problems. I am not sure on the SQL syntax and the person who I usually ask these questions to is offline so I am hoping that someone here can help me.

I am not sure what else to include, so if you need more information, please do let me know.

 

[Ashley]

That was quick! 🙂 Glad you got everything working, Patrick.

 

[Patrick W.]

It's not 100% fixed, but it is working as should for right now. Will work on a more permanent fix tomorrow with my developer. 😛
I also removed the strike in case someone can help with the proper SQL syntax or whatever.