[BETA] MPS Community MOD

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
jazzking2001
Registered User
Posts: 424
Joined: Tue Jul 10, 2007 9:10 pm
Contact:

Re: [BETA] MPS Community MOD

Post by jazzking2001 »

just wondering how is the phpbb3 version coming along
Neocrisis.com- What will you find next
DynoGT
Registered User
Posts: 397
Joined: Fri Jan 13, 2006 10:06 pm
Location: Jacksonville, Fl

Re: [BETA] MPS Community MOD

Post by DynoGT »

2 questions...

I'm now getting this error message when editing profile info.
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
How do I fix that?

And how can I keep the 'friends' pop up from showing after each login?
dturano547
Registered User
Posts: 28
Joined: Tue Jul 29, 2008 3:38 pm

Re: [BETA] MPS Community MOD

Post by dturano547 »

Any updates on a PHPBB 3 version yet?

I would love to put something like this in my forum
dturano547
Registered User
Posts: 28
Joined: Tue Jul 29, 2008 3:38 pm

Re: [BETA] MPS Community MOD

Post by dturano547 »

I get some errors when running this script:
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:

#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 '' at line 24
User avatar
Jadestone
Registered User
Posts: 630
Joined: Tue May 24, 2005 12:54 am
Location: Juno Beach, FL
Contact:

Re: [BETA] MPS Community MOD

Post by Jadestone »

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
My Mods In Development: MPS Mod

MPS Support Site: Click Here
User avatar
Kingdombuilder
Registered User
Posts: 91
Joined: Sat Apr 26, 2008 7:48 am
Location: Flint, MI
Contact:

Re: [BETA] MPS Community MOD

Post by Kingdombuilder »

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 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.
Image
User avatar
keith10456
Registered User
Posts: 2315
Joined: Thu Feb 24, 2005 6:55 pm
Contact:

Re: [BETA] MPS Community MOD

Post by keith10456 »

Kingdombuilder wrote:
...I think that this mod will change the way people look at phpbb sites...
It already has if you use if for phpbb v2 ;)
User avatar
Kingdombuilder
Registered User
Posts: 91
Joined: Sat Apr 26, 2008 7:48 am
Location: Flint, MI
Contact:

Re: [BETA] MPS Community MOD

Post by Kingdombuilder »

keith10456 wrote:
Kingdombuilder wrote:
...I think that this mod will change the way people look at phpbb sites...
It already has if you use if for phpbb v2 ;)
I'm eagerly wating for the phpBB 3 version, I can be patient though...
Image
User avatar
Kingdombuilder
Registered User
Posts: 91
Joined: Sat Apr 26, 2008 7:48 am
Location: Flint, MI
Contact:

Re: [BETA] MPS Community MOD

Post by Kingdombuilder »

When i tried to install the SQL code i got an error.

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
This was the error that I got. i was doing the full install with the SQL. Does anyone have any suggestions?
Image
Post Reply

Return to “[2.0.x] MODs in Development”