Whats this error mean?

mrthunder23 · Post by **mrthunder23** » Wed Jul 27, 2011 6:00 pm

General Error
SQL ERROR [ mysql4 ]

Field 'rpg_post_whisper' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id) VALUES (2, 2, 0, '127.0.0.1', 1311789555, 1, 1, 1, 1, 1, '', 'assss', 'asasas', '2f3e9eccc22ee583cf7bad86c751d865', 0, '', '2o3jgyzt', 1, 0, 7)

BACKTRACE

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

FILE: includes/functions_posting.php
LINE: 1988
CALL: dbal_mysql->sql_query()

FILE: posting.php
LINE: 1116
CALL: submit_post()

Installed a mod and now get this. Just wondering how to interpret it

Post by **KevC** » Wed Jul 27, 2011 6:00 pm

You need to ask for help from the MOD author in the place where you got it.

mrthunder23 · Post by **mrthunder23** » Wed Jul 27, 2011 9:29 pm

Umm... I don't need the mod author, just wondering what the error means. I get that its in X line of code. But what is SQl Error mysql 4

IM guessing I missed a line/variable

Post by **KevC** » Wed Jul 27, 2011 9:30 pm

Google sql default value errors.

mrthunder23 · Post by **mrthunder23** » Wed Jul 27, 2011 9:45 pm

I fixed it. Now I get...

Code: Select all

				'rpg_post_whisper'	=> '')
			);

Line 1727 like said in the error. It's the );

the block of code:

Code: Select all




	// Collect Information
	switch ($post_mode)
	{
		case 'post':
		case 'reply':
			$sql_data[POSTS_TABLE]['sql'] = array(
				'forum_id'			=> ($topic_type == POST_GLOBAL) ? 0 : $data['forum_id'],
				'poster_id'			=> (int) $user->data['user_id'],
				'icon_id'			=> $data['icon_id'],
				'poster_ip'			=> $user->ip,
				'post_time'			=> $current_time,
				'post_approved'		=> $post_approval,
				'enable_bbcode'		=> $data['enable_bbcode'],
				'enable_smilies'	=> $data['enable_smilies'],
				'enable_magic_url'	=> $data['enable_urls'],
				'enable_sig'		=> $data['enable_sig'],
				'post_username'		=> (!$user->data['is_registered']) ? $username : '',
				'post_subject'		=> $subject,
				'post_text'			=> $data['message'],
				'post_checksum'		=> $data['message_md5'],
				'post_attachment'	=> (!empty($data['attachment_data'])) ? 1 : 0,
				'bbcode_bitfield'	=> $data['bbcode_bitfield'],
				'bbcode_uid'		=> $data['bbcode_uid'],
				'post_postcount'	=> ($auth->acl_get('f_postcount', $data['forum_id'])) ? 1 : 0,
				'post_edit_locked'	=> $data['post_edit_locked'],
				'rpg_post_whisper'	=> '')
			);
		break;

Code: Select all

Parse error: syntax error, unexpected ')' in C:\xampp\htdocs\phpBB3\includes\functions_posting.php on line 1727

The error. I have no experience in syntax, so i figure this is a simple character misplace sorta fix

Post by **KevC** » Wed Jul 27, 2011 9:50 pm

This forum isn't for MOD support. You need to ask the author.

mrthunder23 · Post by **mrthunder23** » Wed Jul 27, 2011 9:54 pm

It's not a question of the mod. The mod isn't a problem.

I'm just wondering in that block of code what the syntax error is >.> I think I added something extra or forgot a bracket

Post by **KevC** » Wed Jul 27, 2011 9:56 pm

Get an unmodded file and redo the edit based on the MOD instructions.

mrthunder23 · Post by **mrthunder23** » Wed Jul 27, 2011 10:03 pm

Kevin Clark wrote:Get an unmodded file and redo the edit based on the MOD instructions.

alrighty :p have a good one mate

i fixed it. Had an extra ) just like the error said. pain killers are not friendly

advertisements