• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space

Error creating chv_settings table (update from 2.2.1)

Status
Not open for further replies.

flod

Chevereto Member
Hi, on our server we're currently running an old version of the software, so I bought the network license to upgrade it but I can't manage to install it.

The error I get is:

Code:
Can't create admin user:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbimmagini.chv_settings' doesn't exist

The server is still running Debian 7, but specs seem to be enough based on the requirements (PHP 5.4, Mysql 5.5).

phpinfo() output: http://immagini.mozillaitalia.org/test.php
I checked the existing user with phpMyAdmin and it has full privileges on the table.
Folder is owned by www-data, it's extracted from the 3.7.2 .zip file and only /images has been copied over

Happy to provide all the information requested to debug the issue, but direct access to the server is not really an option since we normally work on it via SSH.
 
Last edited:
Also based on this old post, I checked with this piece of code.

Code:
$dsn = 'mysql:host=localhost;dbname=DBNAME';
$user = 'DBUSER';
$password = 'DBPWD';

try {
    $dbh = new PDO($dsn, $user, $password);
    echo "VERSION: " .  $dbh->getAttr(PDO::ATTR_SERVER_VERSION);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

Running this code with the same data I use in the installation panel, I get this version, which should be fine.
Code:
VERSION: 5.5.47-0+deb7u1
 
There's currently no FTP access (on purpose) to the server, we only manage it through SSH. Is there any way to debug the issue without direct access to the server?

Eventually I can create a user and give to use with SFTP, but I would need to open up permissions and duplicate the current installation+db.
 
Most likely the update procedure is wrong so I need to actually debug the install script. That's why I need access.
 
Status
Not open for further replies.
Back
Top