Fatal error: in /includes/db/dbal.php

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
theaustintroncao
Registered User
Posts: 5
Joined: Sat Sep 18, 2010 9:57 am

Fatal error: in /includes/db/dbal.php

Post by theaustintroncao »

Support Request Template
What version of phpBB are you using? phpBB 3.0.7-PL1
What is your board's URL? http://sloriders.com
Who do you host your board with? doreo
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Fresh Install
Do you have any MODs installed? Yes
Is registration required to reproduce this issue? Yes
What MODs do you have installed? advertisement manager & phpbb calandar
What styles do you currently have installed? prosilver, getaway, hestia blue, getaway green, ficebusi 2, subadreas, subsilver 2, glass
What language(s) is your board currently using? english
Which database type/version are you using? MySQL 4
What is your level of experience? Comfortable with PHP and phpBB
What username can be used to view this issue? Nellie
What password can be used to view this issue? nellie
When did your problem begin? began getting posts from users about 4 or 5 days ago
Please describe your problem. when sending a private message :
Fatal error: in /home/slorider/public_html/includes/db/dbal.php on line 694

was having issues where forums would get mixed together and a few other things so i did a fresh install and a database restore from and reinstalled mods and a day or so later began getting reports of this error.
also had errors returned when posting to forums, but another reinstall corrected that but i am not having any luck getting this issue with the above error being returned when sending a private message.
Generated by SRT Generator ($Rev: 4351 $)
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21121
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Fatal error: in /includes/db/dbal.php

Post by RMcGirr83 »

Try turning on debug mode. Open the config.php file and change this

Code: Select all

//@define('DEBUG', true);
//@define('DEBUG_EXTRA', true);
to this

Code: Select all

@define('DEBUG', true);
@define('DEBUG_EXTRA', true);
then try a pm again and see if any additional information is given for the error.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions | My extensions are updated regularly on github
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
theaustintroncao
Registered User
Posts: 5
Joined: Sat Sep 18, 2010 9:57 am

Re: Fatal error: in /includes/db/dbal.php

Post by theaustintroncao »

@RMCgirr83
Thank you for the fast response.
I removed the // before the two lines in config.php per your instructions to enable debugging, but i get the same error with no additional info:
Fatal error: in /home/slorider/public_html/includes/db/dbal.php on line 694
Please give me any other ideas you may have to help me get this resolved.
thank you
austin
User avatar
soumik
Registered User
Posts: 486
Joined: Tue Nov 06, 2007 7:27 pm
Contact:

Re: Fatal error: in /includes/db/dbal.php

Post by soumik »

Can you please elaborate?
Fatal error: in /home/slorider/public_html/includes/db/dbal.php
Can you tell us the description of the error you see after that?
Powered by chocolate
toonpk
Registered User
Posts: 60
Joined: Tue Aug 31, 2010 5:31 pm
Contact:

Re: Fatal error: in /includes/db/dbal.php

Post by toonpk »

you have installed some mod. and you have done a mistake in this file while changing it. try restoring it from you backup:)
theaustintroncao
Registered User
Posts: 5
Joined: Sat Sep 18, 2010 9:57 am

Re: Fatal error: in /includes/db/dbal.php

Post by theaustintroncao »

@soumik
turned on debugging per instructions in first response to this topic and got same exact error with no additional error or backtrace.

@toonpk prior to posting this topic and just now before posting this reply i have restored both from last working backup, other random backups and original file from phpbb install download and still gettting same error.

thank you for the suggestions and I am open to any new ones or ideas on how i maybe doing something incorrectly.
austin
User avatar
soumik
Registered User
Posts: 486
Joined: Tue Nov 06, 2007 7:27 pm
Contact:

Re: Fatal error: in /includes/db/dbal.php

Post by soumik »

Do you have access to the error_logs? If not, ask your host to provide it to you.
Powered by chocolate
Manny404
Registered User
Posts: 2
Joined: Tue May 23, 2006 8:05 pm

Re: Fatal error: in /includes/db/dbal.php

Post by Manny404 »

Code: Select all

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

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt) VALUES ('Bing [Bot]', 'bing [bot]', '', 0, '', '00', '6', 2, '', 0, 'D j. M Y, H:i', 'de', '7', '', '', 1290287545, 1290287545, 230271, 0, 0, 0, 1290287545, 0, 0, '', 0, 1, '9E8DA7', '', '', '', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', '191a052343aaa1e8')

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 250
CALL: dbal_mysqli->sql_query()

FILE: install/database_update.php
LINE: 1781
CALL: user_add()

FILE: install/database_update.php
LINE: 398
CALL: change_database_data()
The error message isnt visibli on default. I modified the DB script to get it.

I solved the problem by settig '' as DEFAULT Item on all Fields with this error.


PS: Errorlogs are all OK no error there
User avatar
naderman
Consultant
Consultant
Posts: 3735
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: Fatal error: in /includes/db/dbal.php

Post by naderman »

Just for reference you can get the proper error message by adding die($msg_long_text); in line 693 right before trigger_error(false, E_USER_ERROR); in dbal.php.

Manny404: I'm a bit surprised, since user_birthday has a DEFAULT value in regular phpBB installations. Did you install any MODs that modified that column? At what version did you install phpBB originally and where did you get the package from? Which other columns did you have to add a DEFAULT value to?

Thanks!
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman
User avatar
napus
Registered User
Posts: 128
Joined: Sat Apr 25, 2009 12:01 pm
Location: Poland
Contact:

Re: Fatal error: in /includes/db/dbal.php

Post by napus »

naderman wrote:Just for reference you can get the proper error message by adding die($msg_long_text); in line 693 right before trigger_error(false, E_USER_ERROR); in dbal.php.

Code: Select all

. . . . . . . . . . SQL ERROR [ mysqli ]

Column 'user_points' cannot be null [1048]
Locked

Return to “[3.0.x] Support Forum”