[RC] phpBB Blog

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!
Ideas Centre
Locked
User avatar
MichaelC
Consultant
Consultant
Posts: 3642
Joined: Mon Dec 21, 2009 3:36 pm
Location: London, UK
Name: Michael Cullum
Contact:

Re: [RC] phpBB Blog

Post by MichaelC »

Thats a rough approximation and I doubt we'll hit it.

And yes, that error should be fixed in this commit: https://github.com/erikfrerejean/phpBB- ... 05be0b556d but it isn't merged into the main code repository yet.
:)
Formerly known as Unknown Bliss.
Formerly Website Team Lead/Manager & Development Team.
Please don't PM me for support (or stuff that belongs in the forums or tracker) but otherwise feel free
NintendoMii
Registered User
Posts: 547
Joined: Thu Aug 04, 2011 9:08 pm

Re: [RC] phpBB Blog

Post by NintendoMii »

K, thanks. :D
EDIT:
General Error wrote:SQL ERROR [ mysql4 ]

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 '.username, u.user_colour, u.user_id FROM (table_prefix_blog bb CROSS JOIN table_prefix_blog_co' at line 2 [1064]

SQL

SELECT b.*, COUNT(bb.blog_id) as blog_count, COUNT(c.cmnt_id) as cmnts_approved, COUNT(cc.cmnt_id) as cmnts_unapproved, ct.cat_title, ct.cat_id u.username, u.user_colour, u.user_id FROM (table_prefix_ bb CROSS JOIN table_prefix_blog_comments cc CROSS JOIN table_prefix_blog_categories ct CROSS JOIN table_prefix_users u) WHERE ct.cat_id = b.blog_cat_id AND c.cmnt_approved = 1 AND cc.cmnt_approved = 0 AND b.blog_poster_id = u.user_id ORDER BY b.blog_id DESC LIMIT 10

BACKTRACE

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: [ROOT]/blog.php
LINE: 107
CALL: dbal->sql_query_limit()
User avatar
dravpper
Registered User
Posts: 23
Joined: Fri Dec 09, 2011 1:49 am
Name: William

Re: [RC] phpBB Blog

Post by dravpper »

Just try ti install the blog and got the same error as last time

Inserting data in the phpbb_2blog_categories database table.
ERROR: Database table phpbb_2blog_categories does not exist.

Now what though it was fixed
User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: [RC] phpBB Blog

Post by Erik Frèrejean »

Michael, can you please prod me on IRC if you've got time later today? I've got a lot of questions about the internal workings ;)
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)
User avatar
MichaelC
Consultant
Consultant
Posts: 3642
Joined: Mon Dec 21, 2009 3:36 pm
Location: London, UK
Name: Michael Cullum
Contact:

Re: [RC] phpBB Blog

Post by MichaelC »

I'm on now and should be around for about 6ish hours.

I'm going to set a target release date for 1.0.1 as this weekend but that is optimistic and we might not make it due to some quite major changes going on (massive thanks to Erik Frèrejean and imkingdavid).
:)
Formerly known as Unknown Bliss.
Formerly Website Team Lead/Manager & Development Team.
Please don't PM me for support (or stuff that belongs in the forums or tracker) but otherwise feel free
User avatar
master412160
Registered User
Posts: 314
Joined: Sat May 22, 2010 5:45 pm
Name: Max Pen

Re: [RC] phpBB Blog

Post by master412160 »

This is a neat modification! I might use this. :)
Regards, Matt.
User avatar
MichaelC
Consultant
Consultant
Posts: 3642
Joined: Mon Dec 21, 2009 3:36 pm
Location: London, UK
Name: Michael Cullum
Contact:

Re: [RC] phpBB Blog

Post by MichaelC »

Thanks master
:)
Formerly known as Unknown Bliss.
Formerly Website Team Lead/Manager & Development Team.
Please don't PM me for support (or stuff that belongs in the forums or tracker) but otherwise feel free
Peter77sx
Registered User
Posts: 3260
Joined: Wed Nov 09, 2005 2:51 pm

Re: [RC] phpBB Blog

Post by Peter77sx »

edit: ahh my question came out wrong.

Does anyone have a working demo of this?>
User avatar
MichaelC
Consultant
Consultant
Posts: 3642
Joined: Mon Dec 21, 2009 3:36 pm
Location: London, UK
Name: Michael Cullum
Contact:

Re: [RC] phpBB Blog

Post by MichaelC »

There will be once 1.0.1 has been released.
:)
Formerly known as Unknown Bliss.
Formerly Website Team Lead/Manager & Development Team.
Please don't PM me for support (or stuff that belongs in the forums or tracker) but otherwise feel free
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [RC] phpBB Blog

Post by spaceace »

how's the planned release date looking?

very interested in using this :D
User avatar
MichaelC
Consultant
Consultant
Posts: 3642
Joined: Mon Dec 21, 2009 3:36 pm
Location: London, UK
Name: Michael Cullum
Contact:

Re: [RC] phpBB Blog

Post by MichaelC »

Possible but unlikely.
:)
Formerly known as Unknown Bliss.
Formerly Website Team Lead/Manager & Development Team.
Please don't PM me for support (or stuff that belongs in the forums or tracker) but otherwise feel free
User avatar
kas5986
Registered User
Posts: 227
Joined: Sat Dec 26, 2009 11:16 am
Location: Karachi, Pakistan
Name: syed shafiq
Contact:

Re: [RC] phpBB Blog

Post by kas5986 »

I am having this error when ever i try to open blog
Parse error: syntax error, unexpected T_VARIABLE in /home/xxxx/public_html/ghs/blog.php on line 107
i installed with automod !
User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: [RC] phpBB Blog

Post by Erik Frèrejean »

Yes, there are various bugs in the current code. I should be able to patch most of the blocking issues this weekend.
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)
User avatar
kas5986
Registered User
Posts: 227
Joined: Sat Dec 26, 2009 11:16 am
Location: Karachi, Pakistan
Name: syed shafiq
Contact:

Re: [RC] phpBB Blog

Post by kas5986 »

any news ?
ibanezfreak
Registered User
Posts: 5
Joined: Sun Dec 25, 2011 1:01 pm

Re: [RC] phpBB Blog

Post by ibanezfreak »

Sorry for asking a retarded question, but I cant for the life of me figure out how to install this into my forum www.ibanezfreaks.com I couldn't see an installation guide anywhere on this page. Please help.

Thanks
Locked

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