How to restore DB and encryption key

ca someone look this over please. not sure what im doing wrong. ive stepped through the restore process in the screen shots on reddit. if this is a lost cause just let me know.

wrongecho

Hey @pr0tex

"ITFlow DB restoration isn't as easy as its supposed to be"

In the nicest way possible, there is nothing specific here about ITFlow. This is very basic database administration. You should be comfortable with the basics of MariaDB/MySQL, Apache and troubleshooting if you want to self-host ITFlow.

The initial error is that you're trying to re-create the tables. You can either remove this or add the "IF NOT EXISTS". MariaDB docs: https://mariadb.com/kb/en/create-table/#create-table-if-not-exists

The datetime error is because SQL is being too strict about the dates. You should be able to run SET SQL_MODE='ALLOW_INVALID_DATES'; Here's a similar question on Stackoverflow: https://stackoverflow.com/questions/35565128/mysql-incorrect-datetime-value-0000-00-00-000000

You may also be able to workaround both of these by turning off SQL strict mode, but I haven't tested this.

pr0tex

wrongecho thank you for you response. I'm not a dev guy, nor a programmer. like i stated I'm a noob to this side of the world. so the links look like Latin to me. they also don't help me as I'm not versed in Linux as i should be. I'm willing to do the work but am not able to get a full grasp of it all. for me months of data is either lost or locked up in db which i don't have the proper skillset to fix. following other peoples post and recommendations have got this far where i can try simple things and take screenshots. its the minor intricate details that elude me, and that's where the issues are.

Thanks for being patient and trying to help.

wrongecho

Hey @pr0tex

I understand. I've got some spare time this afternoon if you'd like to go through this on a screen share instead?

pr0tex

wrongecho sorry now seeing this, yes id like all the help i can get. dm me so we can arrange better time.

aftechro

hey pr0tex see how you getting on with @wrongecho and if you guys need me to have a second look, let me know. Note that i`m based in Dublin, Ireland - so there may be some delays in answering due time differences.

In your screenshoot, i can see you have restored the db with the tables.

Check the database permissions and match with with the user and password that you set at the beginning.

If you your tables containing data, you are on the right track, the rest is just the matter of configuration

you should have something like this (showing table data):

https://ibb.co/fHqhYvB

https://ibb.co/9WCXpLT

wrongecho

pr0tex - I did email you on your Gmail but not sure if you got it.

aftechro - they need a fresh install and then to restore their backup over it, otherwise they won't get the right table structure as its changed since their backup. Happy for you to take over, I'm not free now till the weekend really.

pr0tex

aftechro hey im up now, not sure if you are

pr0tex

wrongecho aftechro

https://www.reddit.com/user/pr0texx/comments/13efd6x/almost/?utm_source=share&utm_medium=web2x&context=3

aftechro

pr0tex i`ll email you later on on your gmail and we can take it from there

felix

pr0tex You've got the right folks helping you now, I'm just a layman.

I did see your screenshots on Reddit and it reminded me of an issue I had. If your sql mode is set to anything other than "traditional" you'll see you have new clients on the dashboard, but they won't display on the clients page unless you specify dates. You can fix this by adding the following line at the bottom of config.php.

$mysqli->query("SET SESSION sql_mode = 'TRADITIONAL'");

You can alternatively change the mode permanently using phpmyadmin, but I used the first option so I wouldn't affect the other databases I'm hosting.

pr0tex

aftechro in on NYC Time btw

johnny

@felix looks like we have another dev that just popped on board with us @bhopkins0 looking to take a stab at the client, tag, MySQL issue. This is been long standing so we will see what comes of it.

felix

johnny I removed the set session line in config.php and the client page loads as intended on the newest update. Thanks @bhopkins0

aftechro

hey @pr0tex i'm free now. emailed you in the morning (10 hours ago) but did not received any reply back, so not sure if your email on your profile is right or something else there…. i've seen @wrongecho also emailed you and he said the same thing….

wrongecho

This thread has come a bit of a mash up of different issues. Original poster never responded.

Locking to keep things tidy 🙂

« Previous Page