site is broken after updating wrong value : #N/A

Closed

Import WP Pro Updated 3 months ago 9 Replies

Kitaek asked 3 months ago on August 14, 2024 at 4:36 pm

Hi,

In the process of uploading data from google spread sheets, I updated the #N/A value instead of the value that should have originally contained 1842, which is included in custom field.  

After realizing that I had updated it incorrectly, I clicked on the tab where the plugin should work. However, I got an error with the screen shown in the attached image. 

The error message was as follows

\”There has been a critical error on this website. Please check your site admin email inbox for instructions. Learn more about troubleshooting WordPress.\”

Can you please guide me on how to resolve this?

Thanks.

J

James replied Support Agent

3 months ago on August 14, 2024 at 5:08 pm

Hi Kitaek,

Did you make a backup of your website files / database before running the import, that you could restore to?

If not what template / field did you update to N/A? and on what records? As you will need to use a database gui such as phpmyadmin to fix the mistake.

James

J

James replied Support Agent

3 months ago on August 14, 2024 at 5:15 pm

The error from your screenshot, is that everywhere e.g. on the front end of the website, or wp-admin, or on a specific part of the website?

Are you able to access your server log to see what the error is?

James

KL

Kitaek replied

3 months ago on August 14, 2024 at 5:50 pm

Hi James,

Thanks for speeeeeedy response!

1. i got a backup file, fortunately!

2. custom field. I attached an image for this.

3. "a specific part of the website" is broken. It happens when i click the 'card' tab like the image attached.

4. i can access phpmyadmin but have no idea where i can see the error.

Thanks!

J

James replied Support Agent

3 months ago on August 14, 2024 at 6:05 pm

Glad you have a way to restore.

Since the admin area still works, Are you able to re-run the importer with the correct value, does this fix?

The errors would be on the server in a log file and are specific to your server, you could enable the wordpress debug log https://developer.wordpress.org/advanced-administration/debug/debug-wordpress/ this will write the errors in wp-content/debug.log.

 

KL

Kitaek replied

3 months ago on August 14, 2024 at 6:40 pm

I re-run before creating this ticket but the issue occurs.

Here is the error message after debug mode:

Deprecated: Creation of dynamic property Card_Oracle_Loader::$shortcodes is deprecated in /keypele775701/www/wp-content/plugins/card-oracle-premium/includes/class-card-oracle-loader.php on line 52

I attached the file mentioned on the message. But...i think this is not the file for solution. Is it correct?

Here is the line: "$this->shortcodes = array();"

Thanks.

J

James replied Support Agent

3 months ago on August 14, 2024 at 6:48 pm

The line would say Fatal Error or Error, not Deprecated: as a warning

KL

Kitaek replied

3 months ago on August 15, 2024 at 6:17 am

Hi,

I have restored my files to the state before uploading them from a backup file. However, the issue is still occurring. I tried troubleshooting via chatgpt, but then it changed to this message.

“Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 4096 bytes) in /keypele775701/www/wp-includes/meta.php on line 1194”

So I upgraded the memory. But this time, I got an error message like this  

“Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 327680 bytes) in /keypele775701/www/wp-includes/post.php on line 7385”

I don't think a memory upgrade will fix it.

Maybe you could try deleting the folder and json files created yesterday (2024-08-15) in 'wp-content/uploads/importwp'?

 

Thanks

J

James replied Support Agent

3 months ago on August 15, 2024 at 12:12 pm

Hi,

The memory error issue can be caused by alot of things, most related would be the you have a value in one of your imported values causing an endless loop.

Sorry i can help you any further as this issue, deleting the json files will not fix your memory issue, nor will deactivating the importwp plugins as the issue is with the data and how your theme/plugins is reading/using the data.

My only other thought would be since you have a backup would be to create a staging site, remove all the imported records and slowly import them in chunks to see when the site breaks again.

James

KL

Kitaek replied

3 months ago on August 15, 2024 at 2:09 pm

Hi,

All right. Thanks for your great idea and guide!