HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Out of range value

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#106301 (In Topic #20728)
Avatar

Fan in training

Starting seeing errors coming from any module that has tried to write to the DB for some reason. No state has changed Ticket module, Calendar module, galleries module. All are coming up with a common error and stack trace as if it is unable to write to the db. Any Ideas?????


"Unfortunately a query has failed [INSERT INTO ocp_calendar_types (t_external_feed, t_title, t_logo) VALUES ('', -2147471502, 'calendar/system_command')] [
Out of range value for column 't_title' at row 1] (version: 9.0.16, PHP version: 5.3.24, URL: /portal/site/index.php?page=calendar&view=month)"
Back to the top
 
Posted
Rating:
#106302
Avatar

Hmm. What's the highest ID number in the ocp_translate table? Has that been manually written to?

Seems like it is overflowing back into negatives, but shouldn't happen as there's a huge number range before it gets that far.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106303
Avatar

Fan in training

4902 Seems to be the highest Table ID. Im not gonna pretend that I am a pro at this like you and your team. Nothing has changed on server side and/or site side besides content edit in a cataloger module
Back to the top
 
Posted
Rating:
#106304
Avatar

Please try going into phpMyAdmin and repairing all tables.

If that doesn't work, tell us what the result of this query is:
SELECT MAX(id) FROM ocp_translate;


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106309

Non-joined user

results from the

Chris Graham said

Please try going into phpMyAdmin and repairing all tables.

If that doesn't work, tell us what the result of this query is:
SELECT MAX(id) FROM ocp_translate;


Results: 1 row(s) returned value 2147495921

working on phpMyadmin
Back to the top
 
Posted
Rating:
#106310
Avatar

Fan in training

Using MySQL56 workbench no instance of phpMyadmin
Back to the top
 
Posted
Rating:
#106311
Avatar

Ah. There'll be some way to repair in there, not sure how exactly though.

My suspicion is a corrupt ocp_translate table. When it returns the maximum ID value (which ocPortal uses to determine the next), it'll use some cache value from the table – I suspect that a repair will rebuild (=fix) this cache value.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106315
Avatar

Fan in training

From the MySQL workbench executed query

REPAIR Table TABLE Name

Returned repaired status OK. restarted MYSQL and server

no change in error
Back to the top
 
Posted
Rating:
#106317
Avatar

If you want to open a free bug report ticket with server access I'll look directly for you.

https://ocportal.com/site/tickets/ticket.htm?ticket_template=bug&cost=free


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106326
Avatar

Fan in training

Submitted a tracker for issue…

Side note was able to restore DB back to a dump from 1/8.

Had a more recent backup done through portal but when running restore.php or restore_data.php in browser, goes blank??

DB restore did clear issue
Back to the top
 
Posted
Rating:
#106339
Avatar

The ocPortal backup doesn't (cannot) work on all servers, so it's important to always test it before relying on it. We document that quite heavily and uninstall it by default in the Setup Wizard.

I had a closer look at the issue. My best guess is something corrupted in your ocp_translate table, resulting in a row ID jumping from some number, to the maximum. This then caused various knock-on errors. This could be a disk error, an unclean reboot, a bug in MySQL, or someone accidentally typing something wrong when hand-editing the database.
I've never heard of it happening in the whole ocPortal history though, so it's not a regular problem.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: