How do I fix that?No Query
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
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