Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

database upgrade.sql scripts missing #8

Closed
AndreZeug opened this issue Jan 8, 2021 · 5 comments
Closed

database upgrade.sql scripts missing #8

AndreZeug opened this issue Jan 8, 2021 · 5 comments
Labels
bug Something isn't working

Comments

@AndreZeug
Copy link

Realizing that booked is getting SaaS I found this git repository. However here the upgrade.sql scripts are not available in database_schema\upgrades\ etc. which allow to upgrade the database to newer versions. Now I am searching for the upgrade possibility from 2.7 -> 2.8.

Is there any chance to upgrade the database from 2.7 to git-master?
(I can provide upgrade.sql for 2.0 to 2.7)
@treborin
Copy link
Contributor

treborin commented Jan 8, 2021

Hi AndreZeug,

There is a file inside this zip, \database_schema\upgrades\2.8 \ schema.sql with all you need to upgrade from 2.7

@effgarces effgarces added the bug Something isn't working label Jan 8, 2021
@effgarces
Copy link
Collaborator

I just check the zip files and the repo, and you are right, in the repo there isn't a upgrade.sql, but the file is present the zip's, that's probably due to the build process that was used but I haven't investigated that yet. In the meantime, you can use a previous release, or the latest maintenance release https://github.com/effgarces/BookedScheduler/releases/tag/2.8.5.1.
I'm due to release another one, hopefully soon, but with all that's going in the world, my schedule keeps getting messed up.

@AndreZeug
Copy link
Author

Great, thanks a lot!
upgrade.sql from https://github.com/effgarces/BookedScheduler/releases/tag/2.8.5.1. should work for me.
Thanks for taking care of BookedScheduler!

@treborin is it correct that one can upgrade the database with schema.sql? Do you have a documentation about that?

@effgarces
Copy link
Collaborator

effgarces commented Jan 8, 2021 •
edited
Loading

From what I quickly seen the upgrade.sql file is simply a merged version of clean.sql, data.sql and schema.sql, so you should be able to upgrade using all of the files in sequence.

@treborin
Copy link
Contributor

treborin commented Jan 8, 2021 •
edited
Loading

That's right, effgarces. I have checked it manually from 2.7.6 up to 2.8.5, and the the only differences i see are what sql files try to update. Using upgrade.sql against your database (2.7.6), should upgrade nicely up to 2.8.5.

@daj1u06 daj1u06 mentioned this issue Jan 12, 2023
Open
@Nortag82 Nortag82 mentioned this issue Sep 19, 2023
Closed
@victoria-pr victoria-pr mentioned this issue Oct 9, 2023
Closed
effgarces pushed a commit that referenced this issue Feb 5, 2024
@ramartins02
Merge pull request #8 from ramartins02/develop
aa8fe69 
Title
JohnVillalovos added a commit to JohnVillalovos/libre-booking that referenced this issue May 30, 2024
@JohnVillalovos
fix: urlencode error with PHP 8.3
4b3b5b2 
Got the following error:

  Slim Application Error
  The application could not run because of the following error:
  Details
  Code: 8192
  Message:urlencode(): Passing null to parameter #1 ($string) of type string is deprecated
  File:/var/www/html/lib/Server/Url.php
  Line: 52
  Trace:
  #0 [internal function]: Slim\Slim::handleErrors()
  #1 /var/www/html/lib/Server/Url.php(52): urlencode()
  #2 /var/www/html/lib/Application/Schedule/CalendarSubscriptionUrl.php(26): Url->AddQueryString()
  LibreBooking#3 /var/www/html/WebServices/Responses/ResourceResponse.php(82): CalendarSubscriptionUrl->__construct()
  LibreBooking#4 /var/www/html/WebServices/Responses/ResourcesResponse.php(20): ResourceResponse->__construct()
  LibreBooking#5 /var/www/html/WebServices/ResourcesWebService.php(65): ResourcesResponse->__construct()
  LibreBooking#6 [internal function]: ResourcesWebService->GetAll()
  LibreBooking#7 /var/www/html/lib/external/Slim/Router.php(200): call_user_func_array()
  LibreBooking#8 /var/www/html/lib/external/Slim/Slim.php(1218): Slim\Router->dispatch()
  LibreBooking#9 /var/www/html/lib/external/Slim/Middleware/Flash.php(86): Slim\Slim->call()
  LibreBooking#10 /var/www/html/lib/external/Slim/Middleware/MethodOverride.php(94): Slim\Middleware\Flash->call()
  LibreBooking#11 /var/www/html/lib/external/Slim/Middleware/PrettyExceptions.php(67): Slim\Middleware\MethodOverride->call()
  LibreBooking#12 /var/www/html/lib/external/Slim/Slim.php(1167): Slim\Middleware\PrettyExceptions->call()
  LibreBooking#13 /var/www/html/Web/Services/index.php(72): Slim\Slim->run()
  LibreBooking#14 {main}</pre></body></html>
JohnVillalovos pushed a commit to JohnVillalovos/libre-booking that referenced this issue Jul 26, 2024
@jvillal-amp @JohnVillalovos
fix: handle no resources case in schedule
3213ef8 
The user would see "Unknown error" on the page. With this fix they now
see the correct message of "You do not have permission to access one
or more of the requested resources"

Had got this error in the log when the user did not have access to any
resources:

  Uncaught exception: TypeError: implode(): Argument #1 ($array) must be of type array, string given in /var/www/librebooking/lib/Common/SmartyPage.php:907
  #0 /var/www/librebooking/lib/Common/SmartyPage.php(907): implode()
  #1 /var/www/librebooking/tpl_c/bdc8821f0b14313eaf56b1ea126646d5b4ea5097_0.file.schedule.tpl.php(506): SmartyPage->Implode()
  #2 /var/www/librebooking/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_669e13d3aee330_23010540()
  LibreBooking#3 /var/www/librebooking/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
  LibreBooking#4 /var/www/librebooking/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
  LibreBooking#5 /var/www/librebooking/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render()
  LibreBooking#6 /var/www/librebooking/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute()
  LibreBooking#7 /var/www/librebooking/Pages/Page.php(375): Smarty_Internal_TemplateBase->display()
  LibreBooking#8 /var/www/librebooking/Pages/SchedulePage.php(317): Page->Display()
  LibreBooking#9 /var/www/librebooking/Pages/ActionPage.php(32): SchedulePage->ProcessPageLoad()
  LibreBooking#10 /var/www/librebooking/Pages/SecurePage.php(171): ActionPage->PageLoad()
  LibreBooking#11 /var/www/librebooking/Web/schedule.php(8): SecurePageDecorator->PageLoad()
  LibreBooking#12 {main}
@JohnVillalovos JohnVillalovos mentioned this issue Jul 26, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@effgarces @AndreZeug @treborin