Part of the EllisLab Network
pMachine Pro has been replaced by ExpressionEngine, our full featured web publishing solution. Please consider upgrading.
You can download pMachine Pro here: Download pMachine Pro  |  Download Language Packs
   
 
MySQL Error: 1064 only at table pm_event
Posted: 24 January 2006 09:14 PM   [ Ignore ]  
Summer Student
Total Posts:  1
Joined  2006-01-24

Hello,

I try to install pM Pro 2.41 with Version 2.4 Installation Script. Everything workes fine till I get to step 4. All tables except table pm_event are installed without problems. But for table pm_event I get this error:

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 nul' 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

Does anybody know this error? My MySQL and PHP isnt that fluent.

I’m working on Win XP Prof with

xampp 2.1
Apache/2.0.55 (Win32)
PHP/5.0.5
MySQL 5.0.15-nt

Greetings, M.

Profile
 
 
Posted: 31 January 2006 01:51 PM   [ Ignore ]   [ # 1 ]  
Summer Student
Total Posts:  1
Joined  2006-01-31

As you can see I’ve got the same error.

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 nul’ 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

My opinion is, there’s a spelling problem in this line

year char(4) not nul’ at line 4

May anybody tell me how to correct this?

BR

hitzesucher

Profile
 
 
   
 
 
‹‹ Control Panel - Login Issue      Plugins ? ››
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 233, on December 18, 2007 12:04 AM
Total Registered Members: 64509 Total Logged-in Users: 0
Total Topics: 81067 Total Anonymous Users: 0
Total Replies: 436297 Total Guests: 17
Total Posts: 517364    
Members ( View Memberlist )
Active Members: