I’ve seen many comments on 1064 but this question hasn’t been answered (at least not so I can understand it)…

When I run the install file I get this:

MySQL Error: 1064 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 ‘repeat char(2) not null, t_stamp int unsigned not null, year char(4) not null,’ at line 4
Query: create table pm_events ( id int unsigned not null auto_increment primary key, link_id varchar(50) not null, repeat char(2) not null, t_stamp int unsigned not null, year char(4) not null, month char(2) not null, day char(2) not null, show_time char(1) not null, title tinytext not null, description text not null )
Error.  Unable to create table: pm_events

I’ve looked at the MySQL 5.0 manual.  I’m assuming that the error is in one of those three lines listed.  I don’t see anything that I can change in the install file, I’m not very good with MySQL and don’t see the problem.  All other tables are coming in perfectly.

Please help!

Debbie

Debbie, since you’re just starting to use pMachine, I recommend you use ExpressionEngine Core instead. pMachine PRO is no longer being updated. I remember this being an issue in pMachine, but I’ve stopped using it two years ago.

Sue -

I’m not a new user of PMP - I’ve installed it with no issues on three sites in the past few months.  This install is to a host selected by my client with whom I’ve been wrangling out database access and permissions for the past few days.

I’m thinking it must be some issue with the MySQL version they’re using, but I have no idea what it might be.

Debbie

Possibly. You could do an install on a different machine and import the database over.

But I’d try EECore first on that server.

Yes, this is an issue with the MySQL version.

The only way to fix this (that I know of) is to manually create the table in MySQL. I create pm_events using MySQL administrator, copy the output syntax, and paste it into the config.php file. Works like a charm.

to fix this:
repalce line 1380 install.php from:

to