Jump to content

[HH#116734] Urgent Follow-Up: Persistent Database Creation Error Despite Corrective Actions


Recommended Posts

Posted
Username: gjamesbrown76, Server: Tommy, Main domain: turk.helioho.st

Dear HelioHost Support Team,

I hope this message finds you well. Thank you once again for your excellent
support in resolving my previous account issue - your assistance has been
invaluable.

I am writing to request your technical expertise regarding an installation
error I'm encountering with a legally purchased Sngine script from
CodeCanyon. As a beginner in website development, I believe this issue
requires server-side intervention.

Software License Verification:
Yes,I confirm that I possess a valid license for the Sngine software, which
was legally purchased through my Envato Market account. I am using it in
full compliance with the license terms for a single website installation on
my domain.

Technical Issue:
When attempting to install the script via install.php,I encounter
persistent database errors that prevent successful installation.

Error Details:

? Fatal error: Uncaught mysqli_sql_exception: Table 'ads_campaigns' already
exists
? Error occurring in: /home/turk.helioho.st/httpdocs/install.php:7208
? Apache error in bootstrap.php on line 31

Troubleshooting Steps Attempted:

? Multiple installation attempts with correct database credentials
? Verification of configuration file settings
? Direct access via browser to install.php

Request for Assistance:
Could your technical team please help with the following:

1. Investigate potential residual database tables from previous
installation attempts
2. Clear any conflicting tables or reset the database state
3. Ensure a clean database environment for fresh installation

Account Information:

? Database: gjamesbrown76_dodo
? Username: gjamesbrown76

I am prepared to provide any necessary license verification documents upon
request. Thank you for your time and technical assistance in resolving this
matter.

Best regards,
OussAma
Username:gjamesbrown76

  • Thanks 1
Posted

" Fatal error: Uncaught mysqli_sql_exception: Table 'ads_campaigns' already exists"

That's your error.  It can't create tables because they already exist. You need to go into Plesk->Databases->PhpMyAdmin for the database you're using for this software, then drop all the tables. Then you can try installing it a second time.

Alternately, you can delete the entire database and make a new one instead.

Posted
Username: gjamesbrown76, Server: Tommy, Main domain: turk.helioho.st

Dear HelioHost Support Team,

I am writing to urgently follow up on my previous technical support request
regarding a persistent database installation error. I have carefully
implemented the instructions you provided, but the issue remains
unresolved, indicating a more complex underlying problem.

Current Situation:
Despite following your guidance exactly,I continue to encounter the same
fatal error when attempting to install the Sngine software. The error
persists even after comprehensive troubleshooting.

Actions Taken Based on Your Recommendation:

1. Database Table Deletion:
? Accessed Plesk ? Databases ? phpMyAdmin for database gjamesbrown76_dodo
? Selected and dropped all existing tables
? Verified the database was completely empty
2. Complete Database Recreation:
? Deleted the entire gjamesbrown76_dodo database
? Created a new database with the same name
? Updated configuration files with correct credentials

Persistent Error Details:

```
Fatal error: Uncaught mysqli_sql_exception: Table 'ads_campaigns' already
exists in /home/turk.helioho.st/httpdocs/install.php:7208
Stack trace: #0 /home/turk.helioho.st/httpdocs/install.php(7208):
mysqli_next_result()
Apache error: mod_fcgid: stderr: thrown in /home/
turk.helioho.st/httpdocs/bootstrap.php on line 31
```

Critical Observation:
The error continues to occur even with a completely empty
database,suggesting the issue may involve:

? PHP OPcache serving cached database schema information
? Server-side caching mechanisms retaining old table structures
? Database permission issues preventing proper table creation
? Residual temporary files from previous installation attempts

Request for Advanced Assistance:
Given the unusual nature of this persistent error,I kindly request your
technical team to:

1. Clear PHP OPcache and all server caches for my account (gjamesbrown76)
2. Check server error logs for deeper insights into the table creation
failure
3. Verify database user permissions for the account gjamesbrown76
4. Investigate any residual files in my home directory that might be
causing conflict

Account Information:

? Username: gjamesbrown76
? Database: gjamesbrown76_turk
? Domain: turk.helioho.st

I confirm that I have a valid license for the Sngine software and have
followed all installation instructions correctly. This persistent technical
issue is preventing me from using the service I've legitimately paid for.

Thank you for your prompt attention to this matter. I am available to
provide any additional information or cooperate with any troubleshooting
steps your team recommends.

Best regards,
OussAma
Username: gjamesbrown76

Posted

We don't utilize server caching on our PHP instances, so can't be that issue. Any cache used by PHP would be implemented or otherwise controlled within the software you're installing.

I'd attempt to get it to install for you, but we're unable to do so as we don't have the license key needed to install it.

The only other thing I can suggest is that the software is either timing out during installation (there is max runtime limit on PHP processes, which we can increase temporarily if needed), or the software is defective.

  • Krydos locked this topic
Guest
This topic is now closed to further replies.
×
×
  • Create New...