Upgrade

Installation
1

Hello Everyone.
Now i noticed there is a new version of the Gibbon.
But i have trouble how to back up my database, is there on how to do it?
What are the steps because i can’t see backup button on the gibbon page.
Cheers

2

Hi dgago, one option is to use @ross’s Data Admin module (from our Extend page) to create a snapshot. I believe Sandra recommends this for non-production systems.

I use the mysqld Linux CLI command, combined with cron for scheduling, to backup our database nightly. When I need to take an immediately backup, I use an SQL client (e.g. phpmyadmin on the web, Sequel Pro on Mac, DBeaver across a variety of OSes, etc) to download the entire database in compressed SQL format.

Hope this helps!

3

Thanks for the reply.
I’m not that expert. But my issue phpadmin i did export into sql is that what you call backup?
Also when i upload the files via ftp where do i upload to… do i replace existing files or is there a specific folder i must transfer the files to.
I’m sorry if is too much to ask.

4

also where is the database i mean which folder is it?

5

Hi,

I see the new v18 released, I try to upgrade my current test setup which is v17, I follow the guide said to backup db and I also make a copy of gibbon to my local store. I unzip and rename the folder to my current gibbon folder name. I overwrite all except the modules and themes but. when finish I try to access the url as usual I got below error, don’t know what is it. Kindly advise is it I need to exclude some files to overwrite beside modules & themes?

Warning: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘test1.gibbonstaffcoverage’ doesn’t exist in C:\xampp\htdocs\test1\src\Database\Connection.php on line 198

Warning: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘test1.gibbonstaffcoverage’ doesn’t exist in C:\xampp\htdocs\test1\src\Database\Connection.php on line 198

Fatal error: Uncaught Error: Call to undefined method PDOStatement::toDataSet() in C:\xampp\htdocs\test1\src\Domain\QueryableGateway.php:101 Stack trace: #0 C:\xampp\htdocs\test1\src\Domain\Staff\StaffCoverageGateway.php(98): Gibbon\Domain\QueryableGateway->runQuery(Object(Aura\SqlQuery\Mysql\Select), Object(Gibbon\Domain\QueryCriteria)) #1 C:\xampp\htdocs\test1\modules\Timetable\moduleFunctions.php(580): Gibbon\Domain\Staff\StaffCoverageGateway->queryCoverageByPersonCovering(Object(Gibbon\Domain\QueryCriteria), ‘0000000001’) #2 C:\xampp\htdocs\test1\index_tt_ajax.php(73): renderTT(‘4ryo34dx5-eebw-…’, Object(PDO), ‘0000000001’, ‘00000001’, false, 1561342462, ‘’, ‘’, ‘trim’) #3 {main} thrown in C:\xampp\htdocs\test1\src\Domain\QueryableGateway.php on line 101

6
Hi,

I see the new v18 released, I try to upgrade my current test setup which is v17, I follow the guide said to backup db and I also make a copy of gibbon to my local store. I unzip and rename the folder to my current gibbon folder name. I overwrite all except the modules and themes but. when finish I try to access the url as usual I got below error, don’t know what is it. Kindly advise is it I need to exclude some files to overwrite beside modules & themes?

Warning: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘test1.gibbonstaffcoverage’ doesn’t exist in C:\xampp\htdocs\test1\src\Database\Connection.php on line 198

Warning: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘test1.gibbonstaffcoverage’ doesn’t exist in C:\xampp\htdocs\test1\src\Database\Connection.php on line 198

Fatal error: Uncaught Error: Call to undefined method PDOStatement::toDataSet() in C:\xampp\htdocs\test1\src\Domain\QueryableGateway.php:101 Stack trace: #0 C:\xampp\htdocs\test1\src\Domain\Staff\StaffCoverageGateway.php(98): Gibbon\Domain\QueryableGateway->runQuery(Object(Aura\SqlQuery\Mysql\Select), Object(Gibbon\Domain\QueryCriteria)) #1 C:\xampp\htdocs\test1\modules\Timetable\moduleFunctions.php(580): Gibbon\Domain\Staff\StaffCoverageGateway->queryCoverageByPersonCovering(Object(Gibbon\Domain\QueryCriteria), ‘0000000001’) #2 C:\xampp\htdocs\test1\index_tt_ajax.php(73): renderTT(‘4ryo34dx5-eebw-…’, Object(PDO), ‘0000000001’, ‘00000001’, false, 1561342462, ‘’, ‘’, ‘trim’) #3 {main} thrown in C:\xampp\htdocs\test1\src\Domain\QueryableGateway.php on line 101

7

Hi,

Eventually, I forgot to do final step which I need go to system admin to update the database manually, after I click the submit then logout and login again, everything back to normal.

8

Hi @sonnysiah glad to hear you got it sorted. Running the database updates is a vital step! Cheers, Ross.