11.0 install issues

[Jim Kirkpatrick]

I tried upgrading to V11 this morning via SVN. That seemed to be fine. There was an expected upgrade page displayed and then a banner saying:

Upgrade In Progress. If this process is stalled delete * from filestore/tmp/process_locks

There was a file in process_locks, database_update_in_progress. I waited 15 minutes then deleted the file. It came back right away so I let it run for another 45 minutes before deleting again. An hour seems like a long time without any effect.

I successfully reverted to 10.7. Not sure where to go from here.

Jim

[Douglas Thompson]

I just wanted to throw in this thread that I just tried the same thing (upgrading to RS v11.0 via SVN) and it appeared to work until I logged in and got this:

I then closed my browser tab and re-accessed RS and got a screen like the above that also said the "Upgrade In Progress. If this project is stalled..." message that Jim mentioned above.

I was able to revert to RS v10.7 via SVN, just as Jim mentioned above., so I tried upgrading to RS v11.0 again, and this time after I logged in, I got this:

(so it was partially working)

But if I clicked any of the icons for my user or did a search and then tried to view a particular resource or anything, I just got the above screen with an overlay of a spinning gear icon, no matter what I did. And there's no bar at the bottom or icon for accessing it or anything, so it's like it's not fully working, or something...it's very strange.

But, at least it's not a "white screen of death" PHP error :)

Anyway, I've reverted to 10.7 for now since it appears to be working properly.

I'll post in my conversation about 10.7 weirdnesses and the "pulse", but just FYI that this 10.7->11.0->10.7 thing has completely gotten rid of the "pulse", so at least 10.7 is now fully usable :)

[David Ryan]

Just for reference . . . I upgraded from 10.7 to 11.0 and it all went to plan as far as I can tell.

The upgrade process took (maybe) 30 seconds or a minute and I was able to log in straight away.

I haven't done much and probably only had a couple of hundred photos, but I had configured the face recognition and auto-keyword AI functions.

[Jim Kirkpatrick]

I tried to upgrade to v11.0 again and it failed the same way. However, I managed to get the error messages:

#0 /var/www/html/resourcespace/include/database_functions.php(653): errorhandler(1, '...', '...', 7998)
#1 /var/www/html/resourcespace/include/database_functions.php(1125): ps_query('...', Array, '', -1, false)
#2 /var/www/html/resourcespace/include/database_functions.php(853): CheckDBStruct('...', false)
#3 /var/www/html/resourcespace/include/database_functions.php(636): check_db_structs()
#4 /var/www/html/resourcespace/include/resource_functions.php(7998): ps_query('...', Array, '...')
#5 /var/www/html/resourcespace/include/search_functions.php(2441): get_resource_type_fields(Array, '...')
#6 /var/www/html/resourcespace/include/searchbar.php(47): get_simple_search_fields()
#7 /var/www/html/resourcespace/include/header.php(330): include('...')
#8 /var/www/html/resourcespace/pages/check.php(9): include('...') /var/www/html/resourcespace/include/resource_functions.php line 7998: Duplicate entry '0' for key 'resource.no_file'

My guess is that line 7998 in resource_functions.php is the culprit but I'm not a php programmer. That line is:

7991 $params = array_merge($params, $groupparams);
7992
7993 $allfieldsquery = "SELECT " . columns_in("resource_type_field", "rtf") . $restypeselect . "
7994 FROM resource_type_field rtf " . implode(" ", $joins)  . $conditionstring . "
7995 GROUP BY rtf.ref " . $groupcondition . "
7996 ORDER BY rtf.active desc," . $field_order_by . " " . $field_sort;
7997
7998 $allfields = ps_query($allfieldsquery, $params, "schema");

Jim

[Marc]

After upgrading I have a similar issue. The "Sorry, an error has occurred" message pops up randomly, but doing a refresh of the page fixes it. It's workable but annoying.

[Jim Kirkpatrick]

I was able to fix my issue. The resource table in the database was corrupted. The upgrade succeeded !

Jim

[Douglas Thompson]

I'm not super-knowledgeable about programming stuff... How'd you uncorrupt that database table?

Douglas E. Thompson Manager of Web and Electronic Communications Office of Marketing & Communications Ohio Wesleyan University 61 S. Sandusky St. Delaware, OH 43015 Email: deth...@owu.edu Office Phone: 740-368-3356 Cell Phone: 614-582-6564 Website: owu.edu

--
ResourceSpace: Open Source Digital Asset Management
http://www.resourcespace.com
---
You received this message because you are subscribed to a topic in the Google Groups "ResourceSpace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/resourcespace/DLTME4sUUBA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to resourcespac...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/a6aff520-5477-425b-b9f2-c64df2b02c0an%40googlegroups.com.

[Jim Kirkpatrick]

It would take more space than we have here to describe it all. ChatGPT provided the guidance and I applied the SQL commands through phpMyAdmin. 

I was a bit nervous through the whole process but it did work. 

It appears that I was lucky. 

Jim

You received this message because you are subscribed to the Google Groups "ResourceSpace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to resourcespac...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/CAO-97Wdy-NUmAWnA7X9nzo8BpQTyb35M6rE0NrT9mFjMnK8GVA%40mail.gmail.com.

[Douglas Thompson]

So the _big_ question is... Did you deal with the corrupted database _before_ or _after_ the upgrade?

Douglas E. Thompson Manager of Web and Electronic Communications Office of Marketing & Communications Ohio Wesleyan University 61 S. Sandusky St. Delaware, OH 43015 Email: deth...@owu.edu Office Phone: 740-368-3356 Cell Phone: 614-582-6564 Website: owu.edu

To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/CALwOO0WKDhPRinwLB6H6-xBVPQhC9XiVLKp9Ef0gOHGjbUYKSQ%40mail.gmail.com.

[Jim Kirkpatrick]

Before. The corrupted resource table was causing the upgrade to fail. Repairing the database allowed the upgrade to work.

To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/CAO-97WffT3WY_y7uGaEnEymZz%2BMbQCUhqy-%3DdayoWu2RCkgKgw%40mail.gmail.com.

[Douglas Thompson]

Ah gotcha (I'm forwarding all of this info to our IS guy (who _is_ a programmer 😁)

Seems like the kind of problem they'd want to thoroughly test for during beta testing...🙄

Douglas E. Thompson Manager of Web and Electronic Communications Office of Marketing & Communications Ohio Wesleyan University 61 S. Sandusky St. Delaware, OH 43015 Email: deth...@owu.edu Office Phone: 740-368-3356 Cell Phone: 614-582-6564 Website: owu.edu

To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/CALwOO0XapquSVDabiF8aG%3DcBhGRrd75Yq3GBJLXpsYQMD3NntQ%40mail.gmail.com.

[Douglas Thompson]

How did you determine which table was corrupted?

Douglas E. Thompson Manager of Web and Electronic Communications Office of Marketing & Communications Ohio Wesleyan University 61 S. Sandusky St. Delaware, OH 43015 Email: deth...@owu.edu Office Phone: 740-368-3356 Cell Phone: 614-582-6564 Website: owu.edu

On Fri, Jul 10, 2026, 12:16 AM Jim Kirkpatrick <jim.kir...@gmail.com> wrote:

To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/CALwOO0XapquSVDabiF8aG%3DcBhGRrd75Yq3GBJLXpsYQMD3NntQ%40mail.gmail.com.

[Jim Kirkpatrick]

The ResourceSpace error finished on resource.no_file which is a column and index in the resource table. That’s were I started with ChatGPT after finding that the error I was seeing was a generic MySQL error. 

Jim

To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/CAO-97WfuqTsiL5tLHk898KcbbmETM6qUQUbbbXVDfoFoOWVMFQ%40mail.gmail.com.

[Douglas Thompson]

Ah gotcha

Douglas E. Thompson Manager of Web and Electronic Communications Office of Marketing & Communications Ohio Wesleyan University 61 S. Sandusky St. Delaware, OH 43015 Email: deth...@owu.edu Office Phone: 740-368-3356 Cell Phone: 614-582-6564 Website: owu.edu

To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/CALwOO0UAB7gW-Qi%3D_oeuTKoXFb1fG%3DSXafGpTQ1r6C2wxJQXdA%40mail.gmail.com.