"view the page source [on the error page] and you'll see it."

Thank you Ed for helping..

All pages make same error in main directory of vB and admin directory . All php3 files gaiv me same error !

I send you Email did you read it Ed ?

The pmstats table uses the name 'DATETIME' for one of the fields. This is a reserved word by MySQL and causes some versions of MySQL to not accept this. Just found this out as I was switching hosts.

The version I was using was 3.22.27
The version my host is using is: 3.22.14b-gamma-virtual

And when doing the import:

ERROR 1064 at line 195: parse error near 'datetime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
PRIMARY KEY (id)
)' at line 5

sure enough, that's where it chokes. Maybe I missed it (the documentation, except for first-time-install.txt, and I don't see it in there) in the documentation, but I don't remember seeing this as a known bug or issue.

Is there a fix out for this, or do I have to go code-hacking and change the field name and all references to it? :(

Yeah, that was a stupid thing I did. :) You'll have to change the name and then the references.

Eh, no sweat. I've done that in the source code for my site which also barfed when I moved. I never knew since I was using a newer version that allowed it.

BTW, if anyone wants to check it out, http://www.bangable.com. :)

I installed pm 1.2 successfully on vb 1.1.4 but I found why there is a line instead of something maybe a text or image
pls go here to see my screen capture

http://free4home.dns2go.com/~adrian/screenshoot2.gif

Just change the templates and edit that link (and some others too)

How do I install this hack on v1.1.5 ? I'm upgrading from v1.1.2 with PM v0.93 (I think) but am encountering problems a) with the differences between the code in 1.1.5 and b) the differences in the table structure between the two hacks - I run the install script provided and I get errors and it won't allow the changes to be made to the tables...

And before I sit down and upgrade my copy of Vbulletin 1.1.4 to 1.1.5 with pm 1.2.5 installed on 1.1.4 does 1.2.5 of pm work on 1.1.5? (if you could follow all of that)

For everybody who's wondering this PM DOES work with version 1.1.5 I just installed it on my board and everything seems alright, so far.... hehe =D

Check it out: http://www.gamingin3d.com/forum/