furrysound wrote: Hi CMX..
I'm trying to install Beta3 onto php 204 and mysql 3.23.54. I'm following the steps and found that removing the ' s helped me with the alter commands, but when I try the insert commands I get:
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ( allow_news, 1 )
MySQL said:
Unknown column 'allow_news' in 'field list'
I was wondering if you might know what I am doing wrong or missing here. Thanks.
FurrySound{Moo}
furrysound wrote: When I put the ' s back in, this is what I get, hence my attempt at removing them, since for the ALTER TABLE phpbb_topics ADD news_id INT UNSIGNED DEFAULT '0' NOT NULL; lines I had to remove the ' s around the 0 ...
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ( \'allow_news\', \'1\' );
MySQL said:
You have an error in your SQL syntax near '\'allow_news\', \'1\' )' at line 1
I noticed it changes my line, adding in \ s to it.
FurrySound{Moo}
P.S: This is a completely new phpBB installation with nothing added, all it has is the basic Test Topic/Post.
furrysound wrote: Well... that's what I've been using to do the procedures in install.txt .... Pasting the mysql commands... how would I do the insert completely manually, maybe that would work, I don't mind doing it, just not sure exactly what steps I should take etc... Thanks... I'm really hoping to get this working. I'm trying to unite all the news postings for the Chaotic Dreams team, makers of the Chaos mod for Quake2, Unreal and Unreal2003, and your mod is the most promising method to do it.
FurrySound{Moo}
furrysound wrote: I added all the lines manually and it looks to be working. Will be doing some major testing and tweaking tonight. Thanks again for your help with this. Great Mod!!
FurrySound{Moo}
furrysound wrote: hmm... I seem to be missing a space... When looking at a forum, the word 'News:' is listed next to each topic that is news. But there is no space between the ':' and the topic name... ie: 'News:Board is up again' ... so I looked through the code (viewforum.php)... found
$news_label = ( $topic_rowset[$i]['news_id'] > 0 ) ? $lang['News'] . ':' : ''; <-- note the lack of a space
and changed it to
$news_label = ( $topic_rowset[$i]['news_id'] > 0 ) ? $lang['News'] . ':' : ' '; <-- note the space added into the ' ' section.
But I don't see this actually working. Wondering if you had any ideas on what I'm missing here... do I need to use the ASCII code or something instead? Or am I fishing in the wrong ocean? Thanks.
FurrySound{Moo}
Code: Select all
$news_label = ( $topic_rowset[$i]['news_id'] > 0 ) ? $lang['News'] . ': ' : '';
cstotes wrote: So what state of "doneness" is this mod in? It looks awesome but I don't want to install it until it is at a 1.0 stage. Keep up the good work.