| 12345678910111213141516171819202122232425 |
- ---
- title: NoticeTitle Plugin not creating requisite table
- author: notabug.org/chaotickjg
- time: Wed, 01 Apr 2020 20:05:23 UTC
- status: closed
- ---
- author: notabug.org
- time: Wed, 01 Apr 2020 20:05:23 UTC
- content: -----
- 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.
- -----
- author: notabug.org
- time: Wed, 01 Apr 2020 20:46:29 UTC
- content: -----
- 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 :)
- -----
- author: notabug.org
- time: Thu, 02 Apr 2020 16:00:12 UTC
- content: -----
- Indeed I did forget to run the script. After dropping the table then running the checkschema script, the table created itself. Sorry about that.
- -----
|
