Jump to content

Problem with WordPress plugin and Database


msbsurfi

Recommended Posts

I am facing problem while installing STAATIC WordPress plugin. The error shows :

Current version

0.0.0

Target version

1.3.4

Error

Unable to execute query: ' CREATE TABLE wp_staatic_builds ( id mediumint(8) unsigned NOT NULL auto_increment, uuid varchar(40) NOT NULL, entry_url varchar(255) NOT NULL, destination_url varchar(255) NOT NULL, parent_uuid varchar(40), date_created datetime NOT NULL, date_crawl_started datetime, date_crawl_finished datetime, num_urls_crawlable int(11), num_urls_crawled int(11), PRIMARY KEY (id), UNIQUE KEY uuid (uuid) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; ': Table 'wp_staatic_builds' already exists

Link to comment
Share on other sites

Quote

Table 'wp_staatic_builds' already exists

I think that's pretty self explanatory. Either it's already installed or there are remains of a previous (perhaps failed?) installation in your database. If you don't have this extension installed already, backup your WP database, then drop all the tables starting with wp_staatic_ and try installing it again.

Link to comment
Share on other sites

32 minutes ago, wolstech said:

then drop all the tables starting with wp_staatic_ and try installing it again.

Yes, I have dropped tables and reinstalled but no effect. I have tried to install Staatic Plugin on a fresh & new site ( on another domain hosted on heliohost: msbsurfi.helioho.st ) but same message shows. I think the plugin can't be installed properly on heliohost. But I need it to be installed properly.

 

Link to comment
Share on other sites

It sounds like either a bug in the extension or maybe incompatible versions if that's the case. The extension's readme says it needs PHP 7.0 but you're using PHP 8.1, perhaps try changing that domain to PHP 7.x and trying again?

 

Link to comment
Share on other sites

I could installed the plugin and the addon properly but it seems the plugin can't crawl the website due to lower php execution time. Here I have attached the screenshot.

The plugin edition is amazing. It would be of great help if netlify deployment and Cloudflare workers deployment add-ons are also added.

Screenshot_20230108-114231_Chrome.jpg

Link to comment
Share on other sites

The plugin does not work. It shows the same error when I click on "Generate Static Site" . 

I installed the "Simply Static" plugin which can extract a static version successfully but not all functions are satisfactory. 

Another plugin "Staatic" is best for creating static site and automatically deploy to netlify. But this plugin can't be installed properly here. I attached a screenshot.

The modified plugin "wp2Static" will be the best to me when it has- 1. Proper functionality 2. Cloudflare workers auto deployment 3. Netlify auto deployment.

I want to make a blog on https://bangla.msbsurfi.me/ which will be only for a region (Bangladesh). If I host dynamic WordPress site in free hosting, how many visitors can visit the site at the same time? Where can I see on Plesk "how much load my site takes" as overload is not allowed?

 

Screenshot_20230108-183527_Chrome.jpg

Link to comment
Share on other sites

10 hours ago, msbsurfi said:

If I host dynamic WordPress site in free hosting, how many visitors can visit the site at the same time? Where can I see on Plesk "how much load my site takes" as overload is not allowed?

Wordpress causes more load than pretty much any other software you can run. Here's what your load looks like for the last 24 hours:

image.png.ccc174fff0e099200392fa03f46732a7.png

You've used 34.7 GB or memory and 4135 units of CPU for only 352.3 MB of traffic. You're 3rd highest on memory usage for Johnny and highest CPU usage. You'll have access to this information yourself through your dashboard eventually.

It's hard to say how many visitors you can have because the memory and CPU usage varies wildly depending on how many plugins you have, etc.

Link to comment
Share on other sites

3 minutes ago, moneybrz said:

i would recommend making your WordPress site into a static site so you don't use a lot of server resources. there are many plugins that will help you with that. You can also use a caching plugin.

I think that's what he was trying to do...the plugin he's using to generate a static WP site needs a bunch of resources itself though (apparently the install alone needed a really long PHP runtime setting in order to finish without timing out).

Link to comment
Share on other sites

1 minute ago, wolstech said:

I think that's what he was trying to do...the plugin he's using to generate a static WP site needs a bunch of resources itself though (apparently the install alone needed a really long PHP runtime setting in order to finish without timing out).

Yes it can use a lot of resources depending on how big the site is.

Link to comment
Share on other sites

  • 4 weeks later...

I know this is late, but for people who want to convert to static without a plugin. You can try out HTTRACK https://www.httrack.com/ which is an application that works on your computer to do this. You can also use something like Laragon (Windows recommended) or Local by Flywheel (Mac recommended, Linux, or Windows) to host your wordpress site locally and install something like Simply Static or Staatic on it.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...