Users unable to register - "An Error Has Occurred!".

[kat]

Any errors, during the uninstall?

Can you attach the whole file (Subs-members.php) to your next post?

[xJamie]

Any errors, during the uninstall?

Can you attach the whole file (Subs-members.php) to your next post?

No errors during the uninstall.

Please see the attachments.

[kat]

Yurk. "custom_color" isn't even in there.

OK. Do me a favour, just to check something. Rename that file to something like "Subs-members0.php", would you? Then, put a copy of the virgin file, there, in it's place. You can get it from the upgrade archive.

http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-7_upgrade.zip

[xJamie]

Yurk. "custom_color" isn't even in there.

OK. Do me a favour, just to check something. Rename that file to something like "Subs-members0.php", would you? Then, put a copy of the virgin file, there, in it's place. You can get it from the upgrade archive.

http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-7_upgrade.zip

Renamed the file then I put the copy of the virgin file in it's place. Nothing changed.

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

[kat]

Right. So, it's not that file.

You know... At this moment, I think your best bet, would be to do this:

http://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files

As I say, on that page...

Once done, your forum will be in a virgin state, software-wise. All of your members, posts, etc. will be intact. However, none of your mods will be installed now. They will, fortunately, still be in Package Manager. From there, you can either apply/install them, or delete them, as you desire. Any of your mod's settings that are stored in the database will be retained and still be usable when the mod is reinstalled.

Read that page, carefully, though. Particularly, the note about Fix_Packages.php, at the bottom.

[xJamie]

Right. So, it's not that file.

You know... At this moment, I think your best bet, would be to do this:

http://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files

As I say, on that page...

Once done, your forum will be in a virgin state, software-wise. All of your members, posts, etc. will be intact. However, none of your mods will be installed now. They will, fortunately, still be in Package Manager. From there, you can either apply/install them, or delete them, as you desire. Any of your mod's settings that are stored in the database will be retained and still be usable when the mod is reinstalled.

Read that page, carefully, though. Particularly, the note about Fix_Packages.php, at the bottom.

I did everything you said, but it's still the same error showing up:
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

[kat]

Hell's teeth. The database won't repair...

What AM I missing, here? px_settings exists. No question.

That "px." prefix... That's correct, I can see it. Is it not?

I'm sure I'm missing something obvious, here. But, I can't see the wood for the trees...

Sorry that I've buggered you about, with this.

Hang on... I just took another look. Although px_settings exists, in the right pane of phpmyadmin, it's not showing in the left pane. It sure was, when I last looked! The last one, there, is px_permission_profiles. That's odd, innit?

This gets weirder by the minute. It's sure not like that in my CPanel.

Let me sleep on it...

With any luck, someone will put us out of our misery, by morning.

[mashby]

How did you create the members that were there before? I was just in your phpmyadmin looking at px and now it's gone (again). How are you installing SMF exactly?

[xJamie]

How did you create the members that were there before? I was just in your phpmyadmin looking at px and now it's gone (again). How are you installing SMF exactly?

How did you create the members that were there before? I was just in your phpmyadmin looking at px and now it's gone (again). How are you installing SMF exactly?

Alright, now I have reinstalled the backups from my old host.

1. I moved all the backup files from my old host to C:\inetpub\wwwroot
2. I installed PhpMyAdmin (Location: C:\inetpub\wwwroot\tofftoff) and imported the .sql database backup file from my old host.
3. I had to overwrite all the prefix; from smf_ to px_
4. I went to http://pwnxile.cm/repair_settings.php and did what I was supposed to.

That's how I installed SMF.

I have included the SMF folder and database in attachments.

[xJamie]

Forum Maintenance > Routine > Check all files against current versions
Output:

Code Select Expand

SMF File Your Version Current Version
SMF Package SMF 2.0.7 ??
Sources ?? ??
Admin-CustomBlocks.php 2.3 ??
Admin.php 2.0 ??
BoardIndex.php 2.0 ??
Calendar.php 2.0 ??
Class-Graphics.php 2.0 ??
Class-Package.php 2.0.7 ??
DbExtra-mysql.php 2.0 ??
DbExtra-postgresql.php 2.0 ??
DbExtra-sqlite.php 2.0 ??
DbPackages-mysql.php 2.0 ??
DbPackages-postgresql.php 2.0 ??
DbPackages-sqlite.php 2.0 ??
DbSearch-mysql.php 2.0 ??
DbSearch-postgresql.php 2.0.7 ??
DbSearch-sqlite.php 2.0.7 ??
Display.php 2.0.7 ??
DumpDatabase.php 2.0 ??
Errors.php 2.0.4 ??
Groups.php 2.0 ??
Help.php 2.0 ??
Karma.php 2.0 ??
Load.php 2.0.7 ??
LockTopic.php 2.0 ??
LogInOut.php 2.0.7 ??
ManageAttachments.php 2.0 ??
ManageBans.php 2.0 ??
ManageBoards.php 2.0 ??
ManageCalendar.php 2.0 ??
ManageErrors.php 2.0.4 ??
ManageMail.php 2.0 ??
ManageMaintenance.php 2.0.7 ??
ManageMembergroups.php 2.0.7 ??
ManageMembers.php 2.0 ??
ManageNews.php 2.0.5 ??
ManagePaid.php 2.0.3 ??
ManagePermissions.php 2.0 ??
ManagePosts.php 2.0 ??
ManageRegistration.php 2.0 ??
ManageScheduledTasks.php 2.0 ??
ManageSearch.php 2.0 ??
ManageSearchEngines.php 2.0 ??
ManageServer.php 2.0.5 ??
ManageSettings.php 2.0.6 ??
ManageSmileys.php 2.0 ??
Memberlist.php 2.0.2 ??
MessageIndex.php 2.0.2 ??
ModerationCenter.php 2.0.1 ??
Modlog.php 2.0.7 ??
MoveTopic.php 2.0 ??
News.php 2.0.7 ??
Notify.php 2.0 ??
PackageGet.php 2.0 ??
Packages.php 2.0.2 ??
PersonalMessage.php 2.0.5 ??
Poll.php 2.0 ??
PortalAdminArticles.php ?? ??
PortalAdminBlocks.php ?? ??
PortalAdminMain.php ?? ??
PortalAdminPages.php ?? ??
PortalAdminShoutbox.php ?? ??
PortalArticles.php ?? ??
PortalBlocks.php ?? ??
PortalMain.php ?? ??
PortalPages.php ?? ??
PortalShoutbox.php ?? ??
Post.php 2.0.7 ??
PostModeration.php 2.0 ??
Printpage.php 2.0 ??
Profile-Actions.php 2.0.6 ??
Profile-Modify.php 2.0.7 ??
Profile-View.php 2.0.5 ??
Profile.php 2.0.6 ??
QueryString.php 2.0.7 ??
Recent.php 2.0 ??
Register.php 2.0.7 ??
Reminder.php 2.0.4 ??
RemoveTopic.php 2.0 ??
RepairBoards.php 2.0 ??
Reports.php 2.0 ??
SSI.php 2.0.7 ??
ScheduledTasks.php 2.0.7 ??
Search.php 2.0.7 ??
SearchAPI-Custom.php 2.0 ??
SearchAPI-Fulltext.php 2.0 ??
SearchAPI-Standard.php 2.0 ??
Security.php 2.0.3 ??
SendTopic.php 2.0 ??
SplitTopics.php 2.0 ??
Stats.php 2.0 ??
Subs-Admin.php 2.0 ??
Subs-Auth.php 2.0.7 ??
Subs-BoardIndex.php 2.0 ??
Subs-Boards.php 2.0 ??
Subs-Calendar.php 2.0 ??
Subs-Categories.php 2.0 ??
Subs-Charset.php 2.0 ??
Subs-Compat.php 2.0 ??
Subs-CustomBlocks.php 2.3 ??
Subs-Db-mysql.php 2.0.4 ??
Subs-Db-postgresql.php 2.0.4 ??
Subs-Db-sqlite.php 2.0 ??
Subs-Editor.php 2.0.7 ??
Subs-Graphics.php 2.0 ??
Subs-List.php 2.0 ??
Subs-Membergroups.php 2.0 ??
Subs-Members.php 2.0.7 ??
Subs-MembersOnline.php 2.0 ??
Subs-Menu.php 2.0.1 ??
Subs-MessageIndex.php 2.0 ??
Subs-OpenID.php 2.0 ??
Subs-Package.php 2.0.1 ??
Subs-Portal.php ?? ??
Subs-PortalAdmin.php ?? ??
Subs-Post.php 2.0.7 ??
Subs-Recent.php 2.0 ??
Subs-SimpleColorizer.php ?? ??
Subs-Sound.php 2.0 ??
Subs.php 2.0.7 ??
Subscriptions-PayPal.php 2.0.3 ??
Themes.php 2.0.4 ??
ViewQuery.php 2.0 ??
Who.php 2.0.2 ??
Xml.php 2.0 ??
subscriptions.php 2.0.2 ??
Default Templates ?? ??
Admin.template.php 2.0 ??
BoardIndex.template.php 2.0 ??
Calendar.template.php 2.0 ??
Compat.template.php 2.0 ??
CustomBlocks.template.php 2.1 ??
Display.template.php 2.0 ??
Errors.template.php 2.0 ??
GenericControls.template.php 2.0 ??
GenericList.template.php 2.0 ??
GenericMenu.template.php 2.0 ??
Help.template.php 2.0.6 ??
Login.template.php 2.0 ??
ManageAttachments.template.php 2.0 ??
ManageBans.template.php 2.0 ??
ManageBoards.template.php 2.0 ??
ManageCalendar.template.php 2.0 ??
ManageMail.template.php 2.0 ??
ManageMaintenance.template.php 2.0 ??
ManageMembergroups.template.php 2.0 ??
ManageMembers.template.php 2.0 ??
ManageNews.template.php 2.0 ??
ManagePaid.template.php 2.0 ??
ManagePermissions.template.php 2.0 ??
ManageScheduledTasks.template.php 2.0 ??
ManageSearch.template.php 2.0 ??
ManageSmileys.template.php 2.0 ??
Memberlist.template.php 2.0 ??
MessageIndex.template.php 2.0 ??
ModerationCenter.template.php 2.0 ??
MoveTopic.template.php 2.0 ??
Notify.template.php 2.0 ??
Packages.template.php 2.0 ??
PersonalMessage.template.php 2.0 ??
Poll.template.php 2.0 ??
Portal.template.php ?? ??
PortalAdmin.template.php ?? ??
PortalAdminArticles.template.php ?? ??
PortalAdminBlocks.template.php ?? ??
PortalAdminPages.template.php ?? ??
PortalAdminShoutbox.template.php ?? ??
PortalArticles.template.php ?? ??
PortalPages.template.php ?? ??
PortalShoutbox.template.php ?? ??
Post.template.php 2.0 ??
Printpage.template.php 2.0 ??
Profile.template.php 2.0 ??
Recent.template.php 2.0 ??
Register.template.php 2.0 ??
Reminder.template.php 2.0 ??
Reports.template.php 2.0 ??
Search.template.php 2.0 ??
SendTopic.template.php 2.0 ??
Settings.template.php 2.0 ??
SplitTopics.template.php 2.0 ??
Stats.template.php 2.0 ??
Themes.template.php 2.0.7 ??
Who.template.php 2.0 ??
Wireless.template.php 2.0 ??
Xml.template.php 2.0 ??
index.template.php 2.0 ??
Language Files ?? ??
Admin.english.php 2.0 ??
EmailTemplates.english.php 2.0 ??
Errors.english.php 2.0 ??
Help.english.php 2.0 ??
Install.english.php 2.0 ??
Login.english.php 2.0 ??
ManageBoards.english.php 2.0 ??
ManageCalendar.english.php 2.0 ??
ManageMail.english.php 2.0 ??
ManageMaintenance.english.php 2.0 ??
ManageMembers.english.php 2.0 ??
ManagePaid.english.php 2.0 ??
ManagePermissions.english.php 2.0 ??
ManageScheduledTasks.english.php 2.0 ??
ManageSettings.english.php 2.0 ??
ManageSmileys.english.php 2.0 ??
Manual.english.php 2.0 ??
ModerationCenter.english.php 2.0 ??
Modifications.english.php ?? ??
Modlog.english.php 2.0 ??
Packages.english.php 2.0 ??
PersonalMessage.english.php 2.0 ??
Post.english.php 2.0 ??
Profile.english.php 2.0 ??
Reports.english.php 2.0 ??
SPortal.english.php 2.3.5 ??
SPortalAdmin.english.php 2.3.5 ??
SPortalHelp.english.php 2.3.5 ??
Search.english.php 2.0 ??
Settings.english.php 2.0 ??
Stats.english.php 2.0 ??
Themes.english.php 2.0 ??
Who.english.php 2.0 ??
Wireless.english.php 2.0 ??
index.english.php 2.0.7 ??
SPortal.english-utf8.php 2.3.5 ??
SPortalAdmin.english-utf8.php 2.3.5 ??
SPortalHelp.english-utf8.php 2.3.5 ??
Current Templates ?? ??
BoardIndex.template.php ?? ??
MessageIndex.template.php ?? ??
Settings.template.php ?? ??
index.template.php ?? ??

Forum Maintenance > Routine > Find and repair any errors
Output: Congratulations, no errors found! Thanks for checking.

Forum Maintenance > Routine > Recount all forum totals and statistics
Output: The maintenance task 'Recount all forum totals and statistics' was executed successfully.

Forum Maintenance > Routine > Empty out unimportant logs
Output: The maintenance task 'Empty out unimportant logs' was executed successfully.

Forum Maintenance > Routine > Empty the file cache
Output: The maintenance task 'Empty the file cache' was executed successfully.

After I did everything in the routine, I went to PhpMyAdmin and ran the SQL query fix through all tables:
Your SQL query has been executed successfully.

I have tried everything but the Database Error won't be fixed.


EDIT: Here is the error logs:

217.xxx.205.25   
   Reverse chronological order of list Today at 09:54:13 pm
Apply Filter: Only show the error messages of this session 2f77113d973b78d900a84cb9aef31746
Apply Filter: Only show the errors of this type Type of error: Database
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=register2Apply Filter: Only show the errors with the same messageDatabase Error: Field 'custom_color' doesn't have a default valueApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Members.php
Line: 772
   Apply Filter: Only show the error messages of this member Guest
Apply Filter: Only show the error messages of this IP address 141.xxx.99.160   
   Reverse chronological order of list Today at 09:51:20 pm
Apply Filter: Only show the error messages of this session 34f13237a750075c830548142d7c18c7
Apply Filter: Only show the errors of this type Type of error: Database
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=register2Apply Filter: Only show the errors with the same messageDatabase Error: Field 'custom_color' doesn't have a default valueApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Members.php
Line: 772
   Apply Filter: Only show the error messages of this member Guest
Apply Filter: Only show the error messages of this IP address 141.xxx.99.160   
   Reverse chronological order of list Today at 09:47:10 pm
Apply Filter: Only show the error messages of this session 34f13237a750075c830548142d7c18c7
Apply Filter: Only show the errors of this type Type of error: Database
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=register2Apply Filter: Only show the errors with the same messageDatabase Error: Field 'custom_color' doesn't have a default valueApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Members.php
Line: 772

[xJamie]

Alright, I think this error has nothing to do with the SMF files. It's coming from the database.

Please scroll up and see attachments for my .sql database file.

EDIT: New errors:

Code Select Expand

Guest
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 11:00:16 pm
Apply Filter: Only show the error messages of this session c215741d6f360d1923c70c3e99a0a47d
Apply Filter: Only show the errors of this type Type of error: Database
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=register2Apply Filter: Only show the errors with the same messageDatabase Error: Field 'custom_color' doesn't have a default valueApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Members.php
Line: 772
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: is_dir() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 1630
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: file_exists() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 301
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: is_dir() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 1630
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: file_exists() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 301
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: is_dir() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 1630
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: file_exists() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 301
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: is_dir() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 1630
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: file_exists() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 301
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: is_dir() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 1630
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: file_exists() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 301
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: is_dir() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 1630
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:21 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall2;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: file_exists() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 301
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:08 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: is_dir() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 1630
Apply Filter: Only show the error messages of this member Jamie
Apply Filter: Only show the error messages of this IP address 141.xxx.81.246   
Reverse chronological order of list Today at 10:59:08 pm
Apply Filter: Only show the error messages of this session 637895d1653cc0d48e6d504407467ad3
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URLhttp://pwnxile.cm/index.php?action=admin;area=packages;sa=uninstall;package=CustomBlocks_2.3.tar.gz;pid=13Apply Filter: Only show the errors with the same message2: file_exists() expects parameter 1 to be a valid path, string givenApply Filter: Only show the errors from this file File: C:/inetpub/wwwroot/Sources/Subs-Package.php
Line: 301

[Kindred]

DO NOT EVER give out your database SQL file.

With that, anyone could hack your account password, log in as you and do anything....

Note, I have deleted it

[xJamie]

DO NOT EVER give out your database SQL file.

With that, anyone could hack your account password, log in as you and do anything....

Note, I have deleted it

Many thanks.

Here is a dump of my table px_log_errors, please see attachments.

[Arantor]

And so we're back to the custom_color business. What modification was made to the members table that added such a field?

The problem is that there's no default value for it, and registration which doesn't know about it won't provide a default value for it.

[xJamie]

And so we're back to the custom_color business. What modification was made to the members table that added such a field?

The problem is that there's no default value for it, and registration which doesn't know about it won't provide a default value for it.

I have no idea to be honest. Perhaps it's the smf_log_online table that has crashed?

Please confirm

[Arantor]

Please stop jumping to conclusions. That just wastes everyone's time.

You have a mod that added a column to the smf_members table, called custom_color. It did it badly. This is indisputably shown from your error log.

1. Go to phpMyAdmin, to the smf_members table, select structure, find the custom_color field, select change, set default to 'As defined', make sure the next box is empty and press save.

2. Tell me what mod you installed so I can go smack the author upside the head for doing a terrible job of writing a mod.

[xJamie]

Please stop jumping to conclusions. That just wastes everyone's time.

You have a mod that added a column to the smf_members table, called custom_color. It did it badly. This is indisputably shown from your error log.

1. Go to phpMyAdmin, to the smf_members table, select structure, find the custom_color field, select change, set default to 'As defined', make sure the next box is empty and press save.

2. Tell me what mod you installed so I can go smack the author upside the head for doing a terrible job of writing a mod.

1. This is what I get

Code Select Expand

Query error:
#1101 - BLOB/TEXT column 'custom_color' can't have a default value

2. http://custom.simplemachines.org/mods/index.php?mod=111

[Arantor]

That mod does not create a field called custom_color but one called online_color. It isn't that mod you're using.

And, really? OK, I REALLY need to smack someone upside the head because that's all levels of wrong, but now I can't tell you what to change it to without seeing what the mod would do with it.

[Kindred]

Blob/text?  Wtf??

[Arantor]

Blob/text?  Wtf??

Precisely my point. VARCHAR(255) is *probably* enough but it's not clear without seeing what the mod does.