An Alternative to Efiction

@jimmi

I think you have it wrong for date tmp. All these do not got through cause int is 11 not 10 and default for that is 0

Query: ALTER TABLE `fanfiction_authors` ADD `date_tmp` int(10) unsigned NOT NULL default '0'
Error: (1067) Invalid default value for 'date'

Query: ALTER TABLE `fanfiction_comments` ADD `date_tmp` int(10) unsigned NOT NULL default '0'
Error: (1067) Invalid default value for 'date'

Query: ALTER TABLE `fanfiction_reviews` ADD `date_tmp` int(10) unsigned NOT NULL default '0'
Error: (1067) Invalid default value for 'date'

Query: ALTER TABLE `fanfiction_reviews` ADD `date_tmp` int(10) unsigned NOT NULL default '0'
Error: (1067) Invalid default value for 'date'

Query: ALTER TABLE `fanfiction_stories` ADD `date_tmp` int(10) unsigned NOT NULL default '0'
Error: (1067) Invalid default value for 'date'

fanfiction_log

fanficition_news

All went through just fine so whatever you did to those has to be fixed in the ones up above. I accidentally put reviews twice

fanfiction_log

fanficition_news

All went through just fine so whatever you did to those has to be fixed in the ones up above. I accidentally put reviews twice.

Check these too

fanfiction_stories date
fanfiction_stories updated

@marcy I am lost here.

It should be 10, not 11 - the timestamp has 10 characters.  11 is not the issue, I just wanted to have it correct.

The query is correct...  do it manually and you get the same result.  It is an integer, so the default is 0 or '0' - I checked this and it is normal to use '0'.

I still think that the problem is the former default value for those fields. The code for all fields is just copy with different names, or I am blind to see the difference.

What is your database server? And PHP 8.1, correct?

Maybe this is the solution - create a new file for this update purpose only and log/report each step. Like install.php, with deleting after using. 

Yeah sorry about that I realized that after i posted.

But every time I update it stops on fanfiction_authors and continues on with errors. until then end.

Its like it never wants to change for some reason. I don't know.

My database is mariadb 10 and 8.1 yes. 

Maybe that is the solution to see why date time won't change and sometimes does.

https://simplydanedehaan.com/fiction/browse.php?type=titles

here all dates changed to 1938

Will have to change those manually.

@marcy

if you have a backup of the fanfiction stories table, don't change dates manually.  I use Mysql 8 but I can try my live hosting, it uses Mariadb 10.5 too. But I don't see any other reason for this. I updated the 3.5.2 database to 3.5.6 without any issues yesterday. 

Maybe the solution is to delete the field and add a new one - not change it directly.  I will do some tests as soon as possible. 

I worked yesterday changing the author dates manually. I just need to update the stories dates. Then it should be complete.

@marcy

Do you have zero value in your date field?  Default "0000... etc"? 

I added SQL mode with NO_ZERO_DATE  so it fails in this case. 

I just posted the fix, the change is in includes/mysqli_functions.php dbconnect().

Posted by: @jimmi

↑

@marcy

Do you have zero value in your date field?  Default "0000... etc"? 

I added SQL mode with NO_ZERO_DATE  so it fails in this case. 

I just posted the fix, the change is in includes/mysqli_functions.php dbconnect().

Which table are you talking about?

@marcy It is generally. In your case - when updated failed because there was zero for datetime field. 

Hello!

This thread showed up in one of my searches by pure happenstance. I'm the creator of Fictioneer, and I'm wondering if you still consider using it or whether you encountered problems, have ideas for improvements, etc.

Does anyone even come here anymore? I can see it has been months.

@tetrakern You are doing great work. Thank you for it. I am watching your repo. It looks like this forum is cached and new posts are visible only after login (or some time). If I didn't have notification, I wouldn't know you wrote something.

@jimmi I noticed the cache being not properly purged, yes. I am going to continue to work on Fictioneer, v5.23 is just around the corner too.

@tetrakern Great. Good luck. I wish it were a plugin, not a theme...