How do I fix that?No Query
DEBUG MODE
SQL Error : 1054 Unknown column 'header_option' in 'field list'
UPDATE phpbb_mps SET header_option = '0' WHERE mps_id = 2
Line : 401
File : mps.php
I just wanted to encourage you on a great Idea and manifestation of this mod. I'm anxiously awaiting this mod for phpbb3. I think that this mod will change the way people look at phpbb sites. Keep up the great work.Jadestone wrote:some parts of the sql file are misisng the closing ) add an ) before the ; and it will work.
as for the progress for phpbb3, it is coming, i am not on phpbb much and i do not plan to be on here much until the release of the alpha for mps, not date is set yet. i am working on 6 projects right now, MPS will be done soon tho
It already has if you use if for phpbb v2Kingdombuilder wrote:
...I think that this mod will change the way people look at phpbb sites...
I'm eagerly wating for the phpBB 3 version, I can be patient though...keith10456 wrote:It already has if you use if for phpbb v2Kingdombuilder wrote:
...I think that this mod will change the way people look at phpbb sites...
Code: Select all
Database d60549710 running on MySQL Server Farm 2
Error
SQL-query :
CREATE TABLE `phpbb_mps` (
`mps_id` INT( 11 ) NOT NULL AUTO_INCREMENT,
`page_title` VARCHAR( 150 ) NOT NULL ,
`about` TEXT NOT NULL ,
`meet` TEXT NOT NULL ,
`self_title` VARCHAR( 255 ) NOT NULL ,
`sex` TINYINT( 1 ) NOT NULL ,
`mps_quiz_results` TEXT NOT NULL ,
`song` TEXT NOT NULL ,
`video` TEXT NOT NULL ,
`music_code` TEXT NOT NULL ,
`music_auto_start` TINYINT( 2 ) NOT NULL ,
`mps_views` INT( 11 ) NOT NULL DEFAULT '0',
`mps_home_page` TINYINT( 1 ) NOT NULL DEFAULT '0',
`myspace_url` VARCHAR( 50 ) NOT NULL ,
`mps_comments_display` TINYINT( 2 ) NOT NULL DEFAULT '10',
`mps_friends_display` TINYINT( 2 ) NOT NULL DEFAULT '8',
`private_profile` TINYINT( 1 ) NOT NULL DEFAULT '0',
`mps_report_profile` TINYINT( 1 ) NOT NULL DEFAULT '0',
`mps_profile_warnings` TINYINT( 4 ) NOT NULL DEFAULT '0',
`mps_short_comment_length` INT( 3 ) NOT NULL DEFAULT '150',
`header_option` INT( 2 ) NOT NULL DEFAULT '0',
KEY ( `myspace_url` ) ,
PRIMARY KEY ( `mps_id` )
MySQL said:
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 '' at line 24