Some jpeg photos missing on Apple devices
- Thread starter Alvin63
- Start date
philmckrackon
Well-known member
You make a copy of what ever your production site needs to function.
As an aside, regarding the images not displaying on apple devices, one member found that if she uses a mac computer with firefox then the images display (but this doesn't work on an iphone or ipad on firefox or any other browser). Different operating system. So it's related to mobile ios. Anyway I'm done with trying to work out the whys and wherefores of Apple and would like to try webp on my test site and just check everything goes ok.
So done everything on the list but not quite there because importing the database keeps stopping at p (126 tables). I assume it's too big to import. Could I export and import it in chunks?
philmckrackon
Well-known member
Before you go there, what are your PHP settings for the below settings? You may need to increase them.
memory_limit
post_max_size
upload_max_filesize
How big is the SQL dump?
beerForo
Well-known member
Already done - imported the database in three chunks. Everything seems to be there. So I thought I was all done and got logged in but got this error message when I went to sign in as admin
Any ideas?XF\Db\Exception: MySQL query error [1048]: Column 'ip_id' cannot be null in src/XF/Db/AbstractStatement.php at line 230
- XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 207
- XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 83
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 219
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1572
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1300
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/IpRepository.php at line 34
- XF\Repository\IpRepository->logIp() in src/XF/ControllerPlugin/LoginPlugin.php at line 224
- XF\ControllerPlugin\LoginPlugin->completeLogin() in src/XF/Pub/Controller/LoginController.php at line 165
- XF\Pub\Controller\LoginController->actionLogin() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
Thanks I had a look at that too
With @philmckrackon 's instructions I already had most of it and the server helped me with some bits as hpanel is different.So - zipped public_html and downloaded to computer, uploaded to public_html in test site and unzipped. Password protected it. Edited config.php with new database name etc and the extra two lines. Exported database and imported it to newly setup database for test site. And where I'm at is that error above.
DNS is populated so I can sign in with the new domain name.
Last edited:
Anyway with that database error and not being able to sign in as admin it seems something isn't right. I've done everything else. Maybe I need to start again and upload the database again?
Server is saying the IP ID line should be set to auto increment and gave me some code to run to change it but I'm a bit wary of doing that
Couldn't see anything about auto increment anywhere in the IP ID table to change it to.
Server is saying the IP ID line should be set to auto increment and gave me some code to run to change it but I'm a bit wary of doing that
Couldn't see anything about auto increment anywhere in the IP ID table to change it to.273.3 MiB
Looks like the database import in chunks failed anyway - the final size is smaller than the original 273.3 MiB - so will clear it out and start again and check the php settings to see if I can increase them. Thanks.
Edit - can't increase them. memory limit, post max size and upload max filesize are all on 2048M which is the maximum available. Must be limited by my server plan.
So it looks like I'm stuck importing the database.
The rest of it has all been quite straightforward! But the database exporting and importing isn't succeeding.
Last edited:
A real Firefox for iOS doesn't exist yet, it's just a skin for Safari; Firefox on MacOS is a real Firefox (eg. uses Gecko)
philmckrackon
Well-known member
It's not really wasted time, it is a learning experience...Wasted far too much time on that and gave up - I've just turned on image optimisation and run the cache so they're all webp and all are viewable on apple devices now.
Should have just done that in the first place
If you were to ask me, one thing I learned is that your host is VERY restrictive!
Agree - and my only contact was the server bot who kept sending me on a wild goose chase and contradicting itself.It's not really wasted time, it is a learning experience... View attachment 325242
If you were to ask me, one thing I learned is that your host is VERY restrictive!
But yes it's been a learning experience. I finally learned how to unzip a file inside public html. Something that I had never been able to achieve when uploading a new xenforo site three times previously and every time had to get someone at the server to do it, and they couldn't work out how to do it either! It kept opening in a separate folder outside public_html and then the files couldn't even be moved (due to the server file manager limitations). They usually did manage to move the files but I never knew how they did it. I finally found the solution by watching a youtube video. In their file manager, when you go to extract, it asks for a file name and it won't extract unless you make a new folder (which ends up outside public_html). The solution was to type ./ in for a file name. Seems pretty obvious now I know how! I informed the server bot of this and I hope I have retrained it for the future!
Last edited:
philmckrackon
Well-known member
Hmm... So your host has no live support either by phone or real time chat?
They used to have support via realtime chat but you just get the server bot these days - which to be fair is quite good sometimes but lacking at other times. In the past I've found live support to not always know the answers - the server bot usually does and quite quickly but sometimes gets it wrong. Maybe a lot of shared hosting has these limitations regarding the database importing.
What I wasn't impressed with was even after custom uploading the database in three "sections" - it all appeared to be there but clearly some of it was missing. And that it couldn't import a full zip file in one go.
What I wasn't impressed with was even after custom uploading the database in three "sections" - it all appeared to be there but clearly some of it was missing. And that it couldn't import a full zip file in one go.
Last edited:
I have a few happy members today with ipads who can now see all the photos. Before that the site was a very bad experience for them. I will never use exiftool again! If I had just converted to webp in the first place I wouldn't have needed to exiftool to remove exif data either.
And really appreciate all your help - thank you - and also @beerForo and @bzcomputersIt's not really wasted time, it is a learning experience... View attachment 325242
If you were to ask me, one thing I learned is that your host is VERY restrictive!