This is the error I see
InnoDB: Error: tried to read 16384 bytes at offset 0 819200.
InnoDB: Was only able to read 0.
141103 13:45:11 InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are...
Trying to back up my database for one of my xenForo forums, and no matter what I do I get these errors.
I've tried doing innodb force restores with 1, 2, 3 with similar errors (I might have been doing them wrong).
In any case, I feel like this seems to be the more appropriate forum to post it...
restarting mysql (mariadb) works without any issues. I added into my.cnf file
[mysqld]
innodb_force_recovery = 1
Which still didn't let me show tables, or select anything (crashes as usual).
So I increased the number to 2, and then mysql(mariadb) wouldn't start.
After removing basically all EWR related addons and updating xenForo, i'm not sure it was fixed but I haven't received that error.
Enter password:
mysqldump: Got error: 2013: "Lost connection to MySQL server during query" when using LOCK TABLES
I'm trying to export one of my databases from mysql, but for some reason it won't export through mysql dump or anything. However, the forum itself is running without any issues.
I've tried a few things to have it connect
$ mysql -u root -p
$ use my_database
$ show tables
ERROR 2006(HY000)...
I've heard since xF v1.2 passwords are now encrypted through bcrypt. Does xenForo use the password_hash() function found in php?
Also, are the hashes stored in xf_user_authenticate table? If so, are they stored in the remember_key column?
Also what is the scheme_class there for? Does it...
I've noticed that the getUser returns a JSON object that does not have the user's email nor does it have the user's location.
The user's location is not a big deal, however, I am not sure why the user's email is not available in the object. Any ideas why? I'm not sure what the reasoning behind...
I recommend not buying this plugin until I decide to update it. It's confirmed to not work with xf v1.3 but it is stable for any xF versions below that. Furthermore, as @skiv has pointed out, commenting those lines out makes the plugin work for v1.3 (I cannot confirm, I am not on xF 1.3)
I am...