How to delete page via database?

[Yaroslav Yarovyi, geändert vor 9 Jahren.]

Doing portal customization I encountered the problem:
Some time ago I added several pages to my LR-portal installation. Some of those pages were made hidden. Also custom theme were applied to those pages.
Now when I try to change page skin, in server log I got:

12:44:09,397 INFO  [stdout] (ajp--100.73.220.13-8009-9) 12:44:09,386 ERROR [ajp--100.73.220.13-8009-9][DefaultTransactionExecutor:93] Application exception overridden by commit exception
12:44:09,398 INFO  [stdout] (ajp--100.73.220.13-8009-9) org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update Layout set uuid_=?, groupId=?, companyId=?, userId=?, userName=?, createDate=?, modifiedDate=?, privateLayout=?, layoutId=?, parentLayoutId=?, name=?, title=?, description=?, keywords=?, robots=?, type_=?, typeSettings=?, hidden_=?, friendlyURL=?, iconImage=?, iconImageId=?, themeId=?, colorSchemeId=?, wapThemeId=?, wapColorSchemeId=?, css=?, priority=?, layoutPrototypeUuid=?, layoutPrototypeLinkEnabled=?, sourcePrototypeLayoutUuid=? where plid=?]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
13:20:17,350 INFO  [stdout] (ajp--100.73.220.13-8009-8) Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
13:20:17,360 INFO  [stdout] (ajp--100.73.220.13-8009-8) Caused by: java.sql.BatchUpdateException: Duplicate entry '10230-0-' for key 'IX_BC2C4231'
13:20:17,370 INFO  [stdout] (ajp--100.73.220.13-8009-8) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '10230-0-' for key 'IX_BC2C4231'
13:20:17,439 INFO  [stdout] (ajp--100.73.220.13-8009-8) 13:20:17,437 ERROR [ajp--100.73.220.13-8009-8][render_portlet_jsp:132] null
13:20:17,440 INFO  [stdout] (ajp--100.73.220.13-8009-8) com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '10230-0-' for key 'IX_BC2C4231'

Further more I can't see any options for one of those pages and this page is hidden, so I can't delete or customize page using control-panel. The exception in log is:

13:24:09,148 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/].[jsp]] (ajp--100.73.220.13-8009-18) Servlet.service() for servlet jsp threw exception: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
13:24:09,278 INFO  [stdout] (ajp--100.73.220.13-8009-18) 13:24:09,276 ERROR [ajp--100.73.220.13-8009-18][IncludeTag:129] Current URL /group/control_panel/manage?p_p_auth=RAPdKBlK&p_p_id=156&p_p_lifecycle=2&p_p_state=maximized&p_p_mode=view&p_p_cacheability=cacheLevelPage&doAsGroupId=10230&refererPlid=11055&controlPanelCategory=current_site.pages&_156_treeId=layoutsTree&_156_groupId=10230&_156_tabs1=public-pages&_156_viewLayout=true&_156_struts_action=%2Fgroup_pages%2Fedit_layouts&_156_selPlid=11013&_156_historyKey= generates exception: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
13:24:09,286 INFO  [stdout] (ajp--100.73.220.13-8009-18) java.lang.StringIndexOutOfBoundsException: String index out of range: -1

All newly created pages work normally.

Is there any way to delete page without deleting whole database? Which tables contain information about public pages?
Can I solve this type of problem without dropping my current database?