#118 NoticeTitle Plugin not creating requisite table

Closed
opened 4 years ago by chaotickjg · 2 comments

When I eneabled the NoticeTitle plugin, all posts on my GNU Social instance were replaced with the following error message:

Error showing notice: [Notice_title] DB_DataObject error []: DB Error: no such table

I took a peak at the plugin's code to find the table it was looking for and checked it against the instance's database, and realized the table wasn't there. I looked at the file 'plugins/NoticeTitle/classes/Notice_title.php' to get the table info and I added it to the database manually. This caused my posts to reappear and the plugin seems to function properly now, aside from the fact that it did not create the table it needed on it's own.

In case it matters, I am using MariaDB through the use of PHP's mysql driver.

When I eneabled the NoticeTitle plugin, all posts on my GNU Social instance were replaced with the following error message: Error showing notice: [Notice_title] DB_DataObject error []: DB Error: no such table I took a peak at the plugin's code to find the table it was looking for and checked it against the instance's database, and realized the table wasn't there. I looked at the file 'plugins/NoticeTitle/classes/Notice_title.php' to get the table info and I added it to the database manually. This caused my posts to reappear and the plugin seems to function properly now, aside from the fact that it did not create the table it needed on it's own. In case it matters, I am using MariaDB through the use of PHP's mysql driver.
Diogo Cordeiro commented 4 years ago
Owner

From your config.php in another open issue:

// Uncomment below for better performance. Just remember you must run
// php scripts/checkschema.php whenever your enabled plugins change!
$config['db']['schemacheck'] = 'script';

Have you ran scripts/checkschema.php after enabling that plugin? If you didn't, run it now and close the issue :)

From your config.php in another open issue: ````php // Uncomment below for better performance. Just remember you must run // php scripts/checkschema.php whenever your enabled plugins change! $config['db']['schemacheck'] = 'script'; ```` Have you ran `scripts/checkschema.php` after enabling that plugin? If you didn't, run it now and close the issue :)
chaotickjg commented 4 years ago
Poster

Indeed I did forget to run the script. After dropping the table then running the checkschema script, the table created itself.

Sorry about that.

Indeed I did forget to run the script. After dropping the table then running the checkschema script, the table created itself. Sorry about that.
Sign in to join this conversation.
No Milestone
No assignee
2 Participants
Loading...
Cancel
Save
There is no content yet.