News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

zCommunity 0.8.1 Beta Now available! (supports SMF 2.0 RC1 and 1.1.8)

Started by Charles Hill, June 16, 2008, 03:33:34 PM

Previous topic - Next topic

qubbah

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 4
File: /home/myforum/public_html/forum/Sources/Blog.php
Line: 4405

qubbah

One more.. is there any block code to put in tp block..

Like : the latest blog or latest article in block.
tq

very nice blog...

Charles Hill

#342
Ah ok I found the problem....

Need to change the $blog in the following query to $board...
// let's get all the topics of which we need to refresh the month and year
$request = db_query("
SELECT m.posterTime, t.ID_TOPIC
FROM {$db_prefix}topics AS t
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
WHERE t.ID_BOARD = $blog", __FILE__, __LINE__);


That is located in the initBlog($memID) function in Sources/Blog.php


edit----
I have not tried to figure out how to add a block for Simple Portal... I'm sure I will eventually make an add-on package that will add several simple portal blocks related to blog community, but I am not going to be making add-ons just yet.  Blog Community 2.0.1 beta has had relatively few bugs considering how insane it is.... Hopefully the changes I have made for 2.0.2 Beta will work great and I can get moving on making some templates and add-ons :)


Charles Hill

Quote from: NIBOGO on September 11, 2008, 08:50:42 PM
Charles Hill this mod will be updated to SMF 2.0??

Thanks

PD: Waiting the Blog v2.0.2 :)

Not until I am fairly sure that I am done adding major things to the main files.  I don't want to make a version compatible with SMF 2.0 and then have to change a lot with that version as well as the SMF 1.1.x version.

midas

I had errors with blog_smf11x.

I've un- and re-installed it but I still get permission errors.  If I uninstall it again then remove the SQL entries blog_categories/links/entries (nothing to keep in the blogs...yet), will it create problems with smf?  Will I be able to re-install the blog package (or upgrade to the new one) more easily?

The last question is, should I remove entries in my php files that refer to the blog file?  So far I've removed entries from index.template.php and subs.php.
Would be nice to get some traffic around here...

JournalXtra
121GuitarLessons.com

Charles Hill

All the data in your database tables will be unaffected by installing the new version.  You will want to remove all the bits of Blog Community 1.11 or earlier from your files.

midas

For my instance, I'm not worried about the blog data in my database.  I'm concerned that by deleting the database's references to the blog package then I might render my forum unusable!  (I have backed up my database though).

Are these the only files to hold references to the blog:

index.php
Sources/BoardIndex.php
Sources/ManagePermissions.php
Sources/Post.php
Sources/Profile.php
Sources/RemoveTopic.php
Sources/Subs.php
Sources/Subs-Boards.php
Sources/Subs-Post.php
Themes/index.template.php
Themes/ManageBoards.template.php
Themes/Post.template.php
Themes/Profile.template.php
Themes/style.css
Themes/languages/index.english.php ?

Would be nice to get some traffic around here...

JournalXtra
121GuitarLessons.com

Charles Hill

You're asking about version 1.11?

FreeSporePrints

#349
Hello Charles,
sorry for my stupid question but i don't understand a thing:

Does this mod modify the entire community and will make the forum a blog or what?

I run 2 different no profit communities (www.FreeSporePrints.org and www.FreeSeedsRing.org) and i believe your mod can interest a lot, because users can have a personal diary about your experiments and so on..

Thanks.
F.

Charles Hill

This is an add-on.  It is separate from the forum.  Sorry about that.  I suppose that isn't as clear as it could be :)

midas

Quote from: Charles Hill on September 12, 2008, 01:23:23 AM
You're asking about version 1.11?

I think you were asking me.  Yes, I'm asking about 1.11.
Would be nice to get some traffic around here...

JournalXtra
121GuitarLessons.com

Charles Hill

#352
version 1.11 modified the following SMF source files:
index.php
Sources/BoardIndex.php
Sources/ManagePermissions.php
Sources/Post.php
Sources/ManageBoards.php
Sources/Profile.php
Sources/RemoveTopic.php
Sources/Subs-Boards.php
Sources/Subs-Post.php
Sources/Subs.php

other files modified:
index.template.php
ManageBoards.template.php
Post.template.php
Profile.template.php
style.css
index.english.php
index.english-utf8.php

I've attached the install.xml from v1.11 so that you have a reference for what you should take out.

qubbah

tq for answer..

the new thing is... can i make the blog go to the childbord? not to parent board?

Sudhakar Arjunan

Quote from: Charles Hill on September 11, 2008, 11:30:17 AM
If you have Simple Portal or TinyPortal installed, there will be a problem with the first edit in index.php (when installing Blog Community 2.0.1 Beta)... 2.0.2 Beta has fixed the compatibility issues with Simple Portal and Tiny Portal (I will be releasing this version later today).

Ok Charles, thank you for the beta .
Since i have simple portal i could not install 2.0.1

Waiting for it , thank you Charles Hill.
Working on New Mods & Themes for SMF... Will update soon... My Blog page
My Smf forum : Discuss ITAcumens :: My SMF Forum

midas

#355
Charles, thank you very much.  Couldn't reply this morning (had been awake nearly 24 hours so had to sleep).

If anything goes wrong, I'm sure you know I'll post back here.

Thank you.

Update: so far, so good.  Deleted php references and the SQL references to the blog.  Fingers X.  When they the new version is out of beta, I'll give it a go.
Would be nice to get some traffic around here...

JournalXtra
121GuitarLessons.com

Maska

Quote from: qubbah on September 11, 2008, 11:52:30 AM
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 4
File: /home/myforum/public_html/forum/Sources/Blog.php
Line: 4405

Quote from: Charles Hill on September 11, 2008, 06:26:04 PM
Ah ok I found the problem....

Need to change the $blog in the following query to $board...
// let's get all the topics of which we need to refresh the month and year
$request = db_query("
SELECT m.posterTime, t.ID_TOPIC
FROM {$db_prefix}topics AS t
LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = t.ID_FIRST_MSG)
WHERE t.ID_BOARD = $blog", __FILE__, __LINE__);


That is located in the initBlog($memID) function in Sources/Blog.php


Hi:

My site was the same mistake, but was cleared with your indications.

But now, when i´m going to see blog, error:

"There is no blog with that ID"

I convert a board to blog.


qubbah

#357
is the user can edit their article after submit? There is no icon for edit.


Charles Hill

All the options are in a drop down menu on the article... Make sure your site's permissions are set properly.  Admins can do anything.

QuoteBut now, when i´m going to see blog, error:

"There is no blog with that ID"

I convert a board to blog.

You're getting that message when converting a board to a blog?

Maska

Quote from: Charles Hill on September 12, 2008, 12:21:48 PM
You're getting that message when converting a board to a blog?

No. I convert a board into blog but when I acces board into blog mode, i getting this message:

"There is no blog with that ID"

The URL is hxxp:www.fororecre.com/foro/index.php?blog=46.0 [nonactive]


Advertisement: