[ABD] Slashdot Style News Posting By CMX - 2.0.6

Enki · Post by **Enki** » Sat Oct 25, 2003 7:19 am

I am getting this error:

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '0, 0, 0)' at line 1

INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, forum_id, news_id, topic_status, topic_type, topic_vote) VALUES ('News', 2, 1067065875, 2, ,0, 0, 0)

Line : 258
File : /usr/local/psa/home/vhosts/****.com/httpdocs/forums/includes/functions_post.php

uchlee · Post by **uchlee** » Thu Oct 30, 2003 8:53 am

Enki wrote: I am getting this error:

Code: Select all

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '0, 0, 0)' at line 1

INSERT INTO phpbb_topics (topic_title, topic_poster, topic_time, forum_id, news_id, topic_status, topic_type, topic_vote) VALUES ('News', 2, 1067065875, 2, ,0, 0, 0)

Line : 258
File : /usr/local/psa/home/vhosts/****.com/httpdocs/forums/includes/functions_post.php

I had the same error but figured out what was wrong. Please refer to the post below.

uchlee · Post by **uchlee** » Thu Oct 30, 2003 9:23 am

There are some parts that we should do more than once. while editing files.

For exmaple,

#
#-----[ OPEN ]------------------------------------------
#
includes/functions_post.php

#
#-----[ FIND ]------------------------------------------
#
global $userdata, $user_ip;

#
#-----[ AFTER, ADD ]------------------------------------------
#
// BEGIN cmx_slash_news_mod
if( isset( $news_category ) && is_numeric( $news_category ) )
{
$news_id = intval( $news_category );
}
else
{
$news_id = 0;
}
// END cmx_slash_news_mod

There are 3 instances of "global $userdata, $user_ip;" in "functions_post.php" so we need to do the process above 3 times.

I can't remember which ones are to be done more than once since I spent hell lot of time.

Can someon please specify which ones are to be edited more than once?

Thanks for the great mod, anyway.

Enki · Post by **Enki** » Sat Nov 01, 2003 7:39 am

thats a bummer,
so I have to wait for someone to help fix this.
damn...

CodeMonkeyX · Post by **CodeMonkeyX** » Fri Nov 07, 2003 8:41 am

Hi all, I have just posted the files to the latest release. Sorry I have not been able to provide support for this mod, but phpBB mod development is not a priority to me now. But I thought I atleast owed it to everyone to release the version I was working on.

Version 1.0.1 should fix a couple of bugs people were having. It also has a lot of new features. You can checkout all the info on my site.

Thanks for all your support with this mod, later.

netclectic · Post by **netclectic** » Fri Nov 07, 2003 9:59 am

Nice one

I noticed some issues in your mod instructions:

the COPY section should be:
copy root/news_rss.php to news_rss.php
copy root/news_index.php to news_index.php
copy root/admin/admin_news_cats.php to admin/admin_news_cats.php
copy root/admin/admin_news.php to admin/admin_news.php
copy root/includes/news.php to includes/news.php
copy root/includes/news_common.php to includes/news_common.php
copy root/includes/news_data.php to includes/news_data.php
copy root/templates/subSilver/news.tpl to templates/subSilver/news.tpl
copy root/templates/subSilver/news_200_rss_body.tpl to templates/subSilver/news_200_rss_body.tpl
copy root/templates/subSilver/admin/news_cat_edit_body.tpl to templates/subSilver/admin/news_cat_edit_body.tpl
copy root/templates/subSilver/admin/news_cat_list_body.tpl to templates/subSilver/admin/news_cat_list_body.tpl
copy root/templates/subSilver/admin/news_config_body.tpl to templates/subSilver/admin/news_config_body.tpl
copy root/language/lang_english/lang_news.php to language/lang_english/lang_news.php
the section that updates the sql in functions_post should be like this:
#
#-----[ FIND ]---------------------------------------------
# around line 268
$sql = ($mode != "editpost") ? "INSERT INTO "

#
#-----[ IN-LINE FIND ]---------------------------------------------
# around line 268 (directly in that line)
(topic_title, topic_poster, topic_time, forum_id,

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------
#
news_id,

#
#-----[ IN-LINE FIND ]---------------------------------------------
# around line 268 (directly in that line)
$current_time, $forum_id,

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------
#
$news_id,

#
#-----[ IN-LINE FIND ]---------------------------------------------
# around line 268 (directly in that line)
"UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject',

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------
#
news_id = $news_id,

there is no need to repeat the initial find, and it make life easier if you just use a small section of the line initially, as it's likely that it could ave been modified by other mods.

I also noticed in includes/news.php there are a few instances of

Code: Select all

$CFG['index_file']

which look like they should be

Code: Select all

$this->config['news_index_file']

which will mean you can also remove the declarations of $CFG from the functions.

apart from those it seems ok, i've not looked at the rss stuff yet though.

CodeMonkeyX · Post by **CodeMonkeyX** » Fri Nov 07, 2003 11:16 am

Thanks ;D

You are correct $CFG is meant to be outta there already. And I will clean up the rest for 1.0.2.

JohnGF · Post by **JohnGF** » Fri Nov 07, 2003 4:52 pm

I use phpbbfm and I got the following error:
Warning: Missing argument 23 for submit_post()
in /.../functions_post.php on line 232.

I know, that I have seen this as an posting error in this or your forum before. But I can find it.

I use phpbbfm RELEASED 206.3.3 and CMX_news Mod 1.0.1

I know, phpbbfm is a heavy modded phpbb, but I need it for a little time. So, can you help me?

And what are the changes, because I`m working on Minerva too.

CodeMonkeyX · Post by **CodeMonkeyX** » Fri Nov 07, 2003 7:36 pm

JohnGF wrote: I use phpbbfm and I got the following error:
Warning: Missing argument 23 for submit_post()
in /.../functions_post.php on line 232.

I know, that I have seen this as an posting error in this or your forum before. But I can find it.

I use phpbbfm RELEASED 206.3.3 and CMX_news Mod 1.0.1

I know, phpbbfm is a heavy modded phpbb, but I need it for a little time. So, can you help me?

And what are the changes, because I`m working on Minerva too.

It takes me long enough to track down problems in regular phpBB, I do not have time to check every branched version of phpBB as well.

There is a full changelist in the install file.

Cross_+_Flame · Post by **Cross_+_Flame** » Sat Nov 08, 2003 8:02 pm

Hello CMX.

I've installed 1.01 on a beta version of my forum.

http://www.crossandflame.com/forumX/news_index.php

As you can see, the images are not appearing. I updated from BETA6 per your instructions, ran through the code trying to make sure the changes were correct, and everything else works fine. The only problem is the IMAGES and the CATEGORIES functions are not working, as the images do not show up.

Check it out if you don't mind and lemme know. Thanks!

CodeMonkeyX · Post by **CodeMonkeyX** » Sat Nov 08, 2003 9:19 pm

Cross_+_Flame wrote: Hello CMX.

I've installed 1.01 on a beta version of my forum.

http://www.crossandflame.com/forumX/news_index.php

As you can see, the images are not appearing. I updated from BETA6 per your instructions, ran through the code trying to make sure the changes were correct, and everything else works fine. The only problem is the IMAGES and the CATEGORIES functions are not working, as the images do not show up.

Check it out if you don't mind and lemme know. Thanks!

When I looked at the properties of the missing images I noticed their URL is http://crossandflame.com/forum/images/news/mandrake.gif, but your forum is installed under http://crossandflame.com/forumX/.

Try updating the News configuration with your correct base URL. That should fix it.

Also you might want to test your page in Mozilla, when I viewed it the news was all squashed to one site of the page.

Thanks for testing it out, is everything else working ok?

Rancisis · Post by **Rancisis** » Sun Nov 09, 2003 12:07 pm

I downloaded the 1.01 version (zip file) of this mod but can't find the /root/includes/functions_news.php file.
I only have news.php, news_commn.php and news_data.php in there.
Any explenation for this???

copy root/includes/functions_news.php to includes/functions_news.php

Mighty_Y · Post by **Mighty_Y** » Sun Nov 09, 2003 12:29 pm

ignore the line, it is a file form one of the earlier beta's , it isn't needed anymore

Rancisis · Post by **Rancisis** » Sun Nov 09, 2003 2:09 pm

What about these

,
templates/subSilver/news_body.tpl
templates/subSilver/news_topics_body.tpl

netclectic · Post by **netclectic** » Sun Nov 09, 2003 2:11 pm

look back a page, i posted some changes that are requried.

advertisements