Forum

Thread tagged as: Problem, Error, Addons

Problem with events app moving old installation

I have moved an old installation of Perch (1.8.3) to a new server, all is working as expected but cannot get Events app items to save without an error in the new install.

I followed the process on the docs (docs.grabaperch.com/perch/building/servers/how-do-i-move-a-perch-site/) though cannot find anywhere to actually download the (I'm guessing, old) compatibility test.

I have also tried reinstalling the Events App along with deleting and reimporting the database, all with the same result.

The diagnostic report is below as well as the debug output from the Events entry page and the debug report showing the error after attempting to save a new event in the Events app. Any help or suggestions getting this functionality back up would be very useful.

Perch: 1.8.3
Installed apps: content (1.8.3), perch_events (1.5), perch_forms (1), perch_gallery (2.1)
PHP: 5.5.38
Zend: 2.5.0
OS: Linux
SAPI: litespeed
MySQL client: 10.0.31-MariaDB
MySQL server: 10.0.31-MariaDB
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, gmp, SPL, iconv, pcntl, readline, Reflection, session, standard, shmop, SimpleXML, exif, tokenizer, xml, litespeed, bcmath, dom, gd, imap, json, mcrypt, mysql, mysqlnd, PDO, pdo_mysql, pdo_sqlite, Phar, posix, sockets, xmlreader, xmlwriter, mhash
GD: Yes
ImageMagick: No
PHP max upload size: 2M
PHP max form post size: 8M
PHP memory limit: 128M
Total max uploadable file size: 2M
Session timeout: 24 minutes
PERCH_DB_USERNAME: oaktreetavern_admin
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: oaktreetavern_perch
PERCH_DB_PREFIX: perch_
PERCH_EMAIL_FROM: admin@oaktreetavern.com.au
PERCH_EMAIL_FROM_NAME: Oak Tree Tavern
PERCH_LOGINPATH: /admin
PERCH_PATH: /home/oaktreetavern/public_html/admin
PERCH_RESFILEPATH: /home/oaktreetavern/public_html/admin/resources
PERCH_RESPATH: /admin/resources
PERCH_HTML5: 1
PERCH_DEBUG: 1
PERCH_ERROR_MODE: DIE
PERCH_AUTH_PLUGIN:
DB tables: perch_contentItems, perch_events, perch_events_categories, perch_events_to_categories, perch_forms, perch_forms_responses, perch_gallery_albums, perch_gallery_image_versions, perch_gallery_images, perch_settings, perch_users
Resource folder writeable: Yes
Native JSON: Yes
Filter functions: Yes
Users: 2
H1: 21fe8858b9c82571c502c1a9bba80ac9
L1: 23a555e4299ad0710d3bef0a8904a5fb
headerColour: #FFFFFF
headerLinkColour: #000000
logoPath: /admin/resources/cp-logo.png
latest_version: 1.8.4
linkColour: #333333
lang: en-gb
hideBranding: 1
helpURL:
siteURL: /
perch_events_detail_url: /events/event.php?event={eventSlug}
editorMayDeleteRegions: 0
perch_events_editorMayManageCats: 1
content_collapseList: 0
perch_forms_editorMayConfigure: 0
perch_forms_editorMayDelete: 0
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_ACCEPT_LANGUAGE: en-au
HTTP_CONNECTION: keep-alive
HTTP_COOKIE: __utma=230803201.1551670826.1501568602.1501568602.1501570949.2; __utmb=230803201.54.10.1501570949; __utmc=230803201; __utmz=230803201.1501568602.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __utmt=1; PHPSESSID=p2olpmcc993pbk92bvcvks89j5
HTTP_HOST: oaktreetavern.com.au
HTTP_REFERER: https://oaktreetavern.com.au/admin/settings/
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/603.3.8 (KHTML, like Gecko) Version/10.1.2 Safari/603.3.8
HTTP_UPGRADE_INSECURE_REQUESTS: 1
DOCUMENT_ROOT: /home/oaktreetavern/public_html
REMOTE_ADDR: 58.96.95.155
REMOTE_PORT: 58097
SERVER_ADDR: 27.131.110.66
SERVER_NAME: oaktreetavern.com.au
SERVER_ADMIN: webmaster@oaktreetavern.com.au
SERVER_PORT: 80
REQUEST_URI: /admin/settings/diagnostics/
SCRIPT_FILENAME: /home/oaktreetavern/public_html/admin/settings/diagnostics/index.php
SCRIPT_URI: https://oaktreetavern.com.au/admin/settings/diagnostics/
SCRIPT_URL: /admin/settings/diagnostics/
SCRIPT_NAME: /admin/settings/diagnostics/index.php
SERVER_PROTOCOL: HTTP/1.1
SERVER_SOFTWARE: LiteSpeed
REQUEST_METHOD: GET
X-LSCACHE: 1
PHP_SELF: /admin/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1501579333.1606
REQUEST_TIME: 1501579333

Debug output when loading the Events App entry form:

DIAGNOSTICS:
SELECT * 
FROM perch_users 
WHERE userEnabled='1' 
AND userID=1
AND userHash='eb2e66c14ab7cd7f5be84218102d998d'
LIMIT 1
UPDATE perch_users SET userHash = 'aa8f732bdf7b4b65ad86de37d20e3992' WHERE userID = 1
SELECT settingID, settingValue FROM perch_settings
SELECT * 
FROM perch_events_categories ORDER BY categoryTitle ASC
SELECT * 
FROM perch_events WHERE eventDateTime>='2017-08-01 00:00:00' ORDER BY eventDateTime
Attempting app installation: perch_events
SHOW TABLES LIKE "perch_events"

Debug output showing error after attempting to save an event:

DIAGNOSTICS:
SELECT * 
FROM perch_users 
WHERE userEnabled='1' 
AND userID=1
AND userHash='8d07d963c4fda791b30c3ef74c3408e4'
LIMIT 1
UPDATE perch_users SET userHash = 'f548171aea15847a1aa22cd172d3068c' WHERE userID = 1
SELECT settingID, settingValue FROM perch_settings
SELECT * 
FROM perch_events_categories ORDER BY categoryTitle ASC
INSERT INTO perch_events(eventID,eventTitle,eventDescRaw,eventDateTime,eventDynamicFields,eventDescHTML,eventSlug) VALUES('','test event','test event content','2017-08-02 00:00:00','[]','
test event content
','2017-08-02-test-event')
Invalid query: Incorrect integer value: '' for column 'eventID' at row 1

Any help gratefully accepted.

Thanks

Marcus

Marcus Lee-Steere

Marcus Lee-Steere 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

That software is so old all we can suggest is that you update.

Thanks, certainly something I had considered and if it were an option at this stage it would be one I actioned. On that basis the suggestion is probably less use but thanks for the time taken to look the problem.