Update via php

Administration
1

Hi Im trying to update the program from v11.0 to v12.0 I read this can happen running the update.php but Im using softaculous and I really dont know how to do that can anybody help me please
regards

2

Luis,

What is the URL for your install? Take that URL (e.g. https://gibbon.example.com) and add /update.php to the end (https://gibbon.example.com/update.php). This will run the required database updates with your needing to be logged in.

I was under the impression that Softaculous could do this automatically, but you would need to contact them to find out as I am no expert (although I do love their work : )

Thanks,

Ross

3

Thanks for the support I got this when trying to update
“Your request failed because your inputs were invalid, or no update was required.”
This, trying to run the update.php file, also looked in ampps (softacolous) for the updated option without success

Any other option for this?

regards

4

Luis, it is possible that Softaculous already ran the updates for you (I think it does that). To check the state of your database, can you look under Options in the login area, and then, under Language, can you tell me if you see Dutch in that list. If you do, then your database is completely up to date, as this was the last change in the v12 update.

5

Thanks Ross

I look in to ampps and doesn`t have that option at less not por gibbon, what i did is to start all over again, this was not to hard, just import the users on CVS, and put my configuration again, no more than 30 minutes, thanks Ross and grate job

6

Luis, thanks for the update. Glad you go it to work. Ross

7

Hi Ross,

I get these errors after trying to update from v10 to v12:

Notice: Undefined index: organisationAdministrator in /var/www/html/gibbon/functions.php on line 3820

Notice: Undefined index: organisationDBA in /var/www/html/gibbon/functions.php on line 3833

Notice: Undefined index: organisationAdmissions in /var/www/html/gibbon/functions.php on line 3846

Notice: Undefined index: organisationHR in /var/www/html/gibbon/functions.php on line 3859

Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘gibbondb.gibbonString’ doesn’t exist’ in /var/www/html/gibbon/src/Gibbon/sqlConnection.php:174 Stack trace: #0 /var/www/html/gibbon/src/Gibbon/sqlConnection.php(174): PDOStatement->execute(Array) #1 /var/www/html/gibbon/src/Gibbon/trans.php(66): Gibbon\sqlConnection->executeQuery(Array, ‘SELECT * FROM g…’) #2 /var/www/html/gibbon/functions.php(43): Gibbon\trans->setStringReplacementList() #3 /var/www/html/gibbon/index.php(98): setStringReplacementList(Object(PDO), ‘y0z7pu6m-54ks-p…’) #4 {main} thrown in /var/www/html/gibbon/src/Gibbon/sqlConnection.php on line 174

You help would be greatly appreciated.

8

Nevermind Think I got it to work.

Thank you and regards

9

Hi Ross,

after upgrading from v10 to v12 it keeps saying:

“Version check successful. Your Gibbon installation is up to date at
12.0.00. If you have recently updated your system files, please check
that your database is up to date in Updates.”

Is this normal and is everything fine?
Where can I check to see if the DB is up to date?

Regards
Jean

10

Jean,

That means your files are up to date. You can check for DB updates in two ways:

  1. Go to /update.php (does not require login, and due to some changes in v12, this is most likely best for you. The update will run automatically.
  2. Go to Admin > System Admin in the main menu and then Update in the module menu. You will be asked to initiate the update.

If you do not run the update, the code will throw database errors as the database structure will not be correct.

Ross

11

Hi Ross,
I am trying to update my version 11 to v12 using the above caption but only getting this error: Your request failed because your inputs were invalid, or no update was required.
Can you tell me what i am doing wrong?

12

Willpro,

Sure, happy to help. Can you give me a step-by-step list of what you are doing leading up to this step?

Ross

13

Actually, I was reading in the download instructions that version 12 can’t be upgraded via the system admin. So I added the update.php to my browser URL but i am not sure if i am placing it in the right area or understand when you say the URL for your install as mentioned in this thread. Is it to be found in the root directory?.

14

It is in the root directory, and should work. Did you first update all of the files from the v12 download over your own files? update.php only takes care of the database update: file update is still manual (something to improve in the future!). Ross

15

Thanks for your quick response. No, I didn’t update the files.

16

Should i update the files from the v12 download first?

17

Yes, do the files first, and then run update.php. If you do it the other way around, update.php has nothing to update, because you still have the old database update files. Ross.

18

Hi Ross,
I did as you suggested and was able to update to new version.
However i am getting this error:
(1) When I select Markbook under the assessment tab i get this error: Parse error: syntax error, unexpected ‘?’ in /home/xxxx/public_html/xxxx.com/modules/Markbook/markbook_view_allClassesAllData.php on line 761
Any suggestions?

19

Hi Willpro,

I’m happy to help troubleshoot this, I wrote much of the v12 markbook stuff. Would you be able to upload the markbook_view_allClassesAllData.php file? The copy I have from v12 doesn’t have a ? near line 761. Without seeing the file it’s hard to know what might be the cause.

Also which version of PHP are you running?

Thanks!

20

Hi Skuipers,
Reading your comment i removed the ? from line 761 and everything seems to working ok.
I am running php 5.5.42.

Thanks very much.