[FINAL] yellow card (+ card ban system)

[R45]

You cannot pass empty data to integer columns. It is not ANSI SQL compliant. What you should to prevent the occurance of empty values is validate your data before building an SQL query. Using the intva()l to force it as an integer would work fine to solve the problem....

[SnowManrcd]

I instaleed yellow card mod a few weeks ago worked perfectly recently I atempted to set up post report froum. when the user clicks submit after filling out the information they get the foillowing error

Code: Select all

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'viewtopic.php?p=2133#2133'> Here to go to the reported post
----------' at line 1

INSERT INTO phpbb_posts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (2136, '(2133)For You Import Fanatics', '4e0b221378', 'Click Here to go to the reported post
--------------------------------

testing')

Line : 288
File : /home/bdweb4724f/ransacknation.com/public_html/phpBB2/includes/functions_post.php

I just need a push in the right direction where should I start looking to solve this problem?? thanks

-Brandon

[Niels Chr. Denmark]

SQL syntax near 'viewtopic

the viewtopic is not even mentioned in the SQL debug message - I asume the error did (it should) have more info than the message you have posted.

please post the complete SQL debug message - or give a URL to a topic inside your forum, where guests can "report"

[SnowManrcd]

Code: Select all

General Error
 
Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'viewtopic.php?p=2975#2975'> Here to go to the reported post
----------' at line 1

INSERT INTO phpbb_posts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (2976, '(2975)test', 'cbb01598f0', 'Click Here to go to the reported post
--------------------------------

testing post')

Line : 288
File : /home/bdweb4724f/ransacknation.com/public_html/phpBB2/includes/functions_post.php

that is the entire error code I recieved,

http://www.ransacknation.com/phpBB2/viewforum.php?f=18

this is a test catagory I created for debugging this problem. you may log in and give me a blue card (SnowMan) atempt to write a mesage and you should also get the error

test account

User : phpbb
Pass : phpbb

[SnowManrcd]

any help wpuld be apreciated

[SnowManrcd]

i give up i see no piont to requesting help here. later.

[SnowManrcd]

its taking forever and no one is helping me with anything so later, i'll just have to figure it out myself.

[[DJ]Ly5y]

have a little problem

I have a problem with the mod becose when i give someone a warrning the windown above his avtar don't show. When i ban a user it not show ether please help. My forum is located at www.paw.pl/~djlysy/forum/
I have checked the installation 2 times and i have done everything perfect as you tod in installation txt. And why the card's are in some window's like this

You see the spaces above those cards :-/


P.S. Sorry for my poor English.

[[DJ]Ly5y]

Help m3

[Niels Chr. Denmark]

i give up i see no piont to requesting help here. later.

sorry for the delaqyed answer, I did try visit your forum, but the test forum, was unawaileble

[SnowManrcd]

i give up i see no piont to requesting help here. later.

sorry for the delaqyed answer, I did try visit your forum, but the test forum, was unawaileble

its kewl I have been working on it for sume time with no sucess and I got a little fusterated, sorry about that I set up the form is only visable formt he phpbb account once its loged in. and forgot to allow that user access to it, It is fixed now the user phpbb has access to the forum

[Niels Chr. Denmark]

switching to PM

[Niels Chr. Denmark]

it could be that some other MOD have changed this line in posting.php

submit_post($mode, $post_data, $return_message, $return_meta, $forum_id, $topic_id, $post_id, $poll_id, $topic_type, $bbcode_on, $html_on, $smilies_on, $attach_sig, $bbcode_uid, str_replace("\'", "''", $username), str_replace("\'", "''", $subject), str_replace("\'", "''", $message), str_replace("\'", "''", $poll_title), $poll_options, $poll_length);

[JKeats]

just installed 1.4.8 of the yellow card hack. i'm running phpBB 2.0.6

when i select a topic to view, i get the following error

Couldn't obtain category list.

DEBUG MODE

SQL Error : 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 'AND c.cat_id<>'25' WHERE f.cat_id = c.cat_id

SELECT c.cat_id, c.cat_title, c.cat_order FROM phpbb_categories c, phpbb_forums f AND c.cat_id<>'25' WHERE f.cat_id = c.cat_id GROUP BY c.cat_id, c.cat_title, c.cat_order ORDER BY c.cat_order

Line : 121
File : /home/nick/public_html/phpBB2/includes/functions.php

line 121 of functions.php is:

Code: Select all

message_die(GENERAL_ERROR, "Couldn't obtain category list.", "", __LINE__, __FILE__, $sql);

that section of code in functions.php (111-128) is:

Code: Select all

//        $is_auth = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata);

        $sql = "SELECT c.cat_id, c.cat_title, c.cat_order
                FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
                ".(($userdata['user_level'] == ADMIN)? "" : " AND c.cat_id<>'".HIDDEN_CAT."'" )."
                WHERE f.cat_id = c.cat_id
                GROUP BY c.cat_id, c.cat_title, c.cat_order
                ORDER BY c.cat_order";
        if ( !($result = $db->sql_query($sql)) )
        {
                message_die(GENERAL_ERROR, "Couldn't obtain category list.", "", __LINE__, __FILE__, $sql);
        }
        
        $category_rows = array();
        while ( $row = $db->sql_fetchrow($result) )
        {
                $category_rows[] = $row;
        }

at someones suggestions i found and corrected

Code: Select all

c.cat_id <> '".HIDDEN_CAT.

in the functions.php file (there was a couple spaces missing... but i still get the error.

any ideas?

[JKeats]

update:

very strange thing happening here...

this is a new board... so prior to adding this mod, i was the only one registered.

in order to test out the mod, i registered a NEW member (i ran into the same error message while registering as well...).

what's interesting... is that when using MY username, i get no errors when viewing topics... however, when trying to use the test member i created, i DO get the error message.

just thought i'd post in case this helps solve the problem.