View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000023SIP Trip PhoneSIP Trip Phonepublic2025-01-17 16:122025-01-17 21:11
Reportermatt Assigned To 
PrioritynormalSeveritycrashReproducibilityalways
Status newResolutionopen 
PlatformnextcloudOS Version30.0.5.1 
Summary0000023: 500 Error when attempting to load app
DescriptionI am getting an internal server error when attempting to load the app.

The following is shown in the logs:

{"reqId":"mtg4T1gbRbvZJ71MXsZd","level":3,"time":"2025-01-17T15:46:02+00:00","remoteAddr":"XX.XX.XX.XX","user":"matt","app":"index","method":"GET","url":"/apps/sip_trip_phone/user/getcontactsnmbrs/%3C?php%20p($userId)&%20?%3E","message":"preg_split(): Argument #2 ($subject) must be of type string, resource given in file '/var/www/html/apps/sip_trip_phone/lib/Service/SphoneService.php' line 122","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:133.0) Gecko/20100101 Firefox/133.0","version":"30.0.5.1","exception":{"Exception":"Exception","Message":"preg_split(): Argument #2 ($subject) must be of type string, resource given in file '/var/www/html/apps/sip_trip_phone/lib/Service/SphoneService.php' line 122","Code":0,"Trace":[{"file":"/var/www/html/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\SIPTripPhone\\Controller\\SphoneController"},"getcontactsnmbrs"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\SIPTripPhone\\Controller\\SphoneController","getcontactsnmbrs",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"userId":"<","_route":"sip_trip_phone.sphone.getcontactsnmbrs"}]},{"file":"/var/www/html/lib/base.php","line":1003,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/sip_trip_phone/user/getcontactsnmbrs/%3C"]},{"file":"/var/www/html/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","Line":146,"Previous":{"Exception":"TypeError","Message":"preg_split(): Argument #2 ($subject) must be of type string, resource given","Code":0,"Trace":[{"file":"/var/www/html/apps/sip_trip_phone/lib/Service/SphoneService.php","line":122,"function":"preg_split","args":["/\\r\\n|\\r|\\n/",null]},{"file":"/var/www/html/apps/sip_trip_phone/lib/Controller/SphoneController.php","line":87,"function":"getcontactsnmbrs","class":"OCA\\SIPTripPhone\\Service\\SphoneService","type":"->","args":["matt"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":208,"function":"getcontactsnmbrs","class":"OCA\\SIPTripPhone\\Controller\\SphoneController","type":"->","args":["<"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\SIPTripPhone\\Controller\\SphoneController"},"getcontactsnmbrs"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\SIPTripPhone\\Controller\\SphoneController"},"getcontactsnmbrs"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\SIPTripPhone\\Controller\\SphoneController","getcontactsnmbrs",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"userId":"<","_route":"sip_trip_phone.sphone.getcontactsnmbrs"}]},{"file":"/var/www/html/lib/base.php","line":1003,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/sip_trip_phone/user/getcontactsnmbrs/%3C"]},{"file":"/var/www/html/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/apps/sip_trip_phone/lib/Service/SphoneService.php","Line":122},"message":"preg_split(): Argument #2 ($subject) must be of type string, resource given in file '/var/www/html/apps/sip_trip_phone/lib/Service/SphoneService.php' line 122","exception":{},"CustomMessage":"preg_split(): Argument #2 ($subject) must be of type string, resource given in file '/var/www/html/apps/sip_trip_phone/lib/Service/SphoneService.php' line 122"}}

I have attempted to change line: https://git.doublebastion.com/sip-trip-phone/blob/develop/lib/Service/SphoneService.php#L110
From: "FROM `*PREFIX*cards`"
To: "FROM `oc_cards`"

to match the database prefix I have but I am still getting the same.

If you need any more info please ask.
Steps To ReproduceAttempt to load SIP trip phone on the latest version (1.1.7)
TagsNo tags attached.

Activities

matt

2025-01-17 16:14

reporter   ~0000073

Sorry: Dup of 0000021

DoubleBastionAdmin

2025-01-17 21:11

administrator   ~0000074

On your server the second query in the 'getcontactsnmbrs' function, in the 'SphoneService.php' file fails to get the data from the 'oc_cards' table. We can't reproduce your issue. You are probably using a different version of MariaDB or PHP. If you log in to your phpMyAdmin, click on the 'oc_cards' table, and click on any blob on the 'carddata' column, can you download the bin file and open it with a text editor to see the vcard data ?

Issue History

Date Modified Username Field Change
2025-01-17 16:12 matt New Issue
2025-01-17 16:14 matt Note Added: 0000073
2025-01-17 21:11 DoubleBastionAdmin Note Added: 0000074