Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] Advanced Permissions error in SQLite [C-Michael83]
#1
MyBB Version: 1.4.4
SQLite Version: 2.8.17
Problem: When you set advanced forum permissions for a usergroup in the ACP, you get a PHP error.
The Error Message:
   
To Reproduce: On a forum running the above requirements, go to ACP > Forums & Posts > **choose forum** > Options > Permissions > **choose usergroup** > Edit Permissions/Set Permissions.
Extra Info: The actual permissions editor is also malformed:
   
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
#2
We're going to need a SQLite Quality Assurance Team now...
-Doug
1scream Founder
Former MyBB Developer & SQA Member
My Twitter
#3
(12-26-2008, 12:13 AM)RenegadeFan Wrote: We're going to need a SQLite Quality Assurance Team now...

Not necessarily so. It's our job, so I'll get onto it this weekend.
#4
What columns are there in your forumpermissions table?
#5
I can't get the SQLite manager to display the list of tables like it used to, dunno what I did to get them to show Undecided
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
#6
If I setup a SQLite forum online somewhere can you reproduce these errors for me on that forum?
#7
Sure will.

Turns out my host was blocking port 21, i asked them to unblock it and they haven't got back to me yet.
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
#8
Ok, here's the fix. In inc/db_sqlite2.php and in inc/db_sqlite3.php find in the show_fields_from function:

$query = $this->simple_select("sqlite_master", "sql", "type = 'table' AND name = '{$this->table_prefix}{$table}'");

replace with

$query = $this->simple_select("sqlite_master", "sql", "type = 'table' AND name = '{$old_tbl_prefix}{$table}'");
#9
Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

With regards,
MyBB Group


Forum Jump:


Users browsing this thread: 1 Guest(s)