search

lantzelot-swe / PCUGameManager

PCUAE Manager (Project Carousel Usb Anniversary Edition) is an application for managing installation of the PCUAE software and managing games and games information used by the carousel for TheC64, The Vic20 and TheC64 Mini.
MIT License
15 stars 0 forks source link

after import #15

Closed Wizart009 closed 1 year ago

Wizart009 commented 1 year ago

got this error after importing gamebase

Could not fetch games by view = Arcade/Collectem Up/2

org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near "em": syntax error) at org.sqlite.core.DB.newSQLException(DB.java:1010) at org.sqlite.core.DB.newSQLException(DB.java:1022) at org.sqlite.core.DB.throwex(DB.java:987) at org.sqlite.core.NativeDB.prepare_utf8(Native Method) at org.sqlite.core.NativeDB.prepare(NativeDB.java:134) at org.sqlite.core.DB.prepare(DB.java:264) at org.sqlite.jdbc3.JDBC3Statement.executeQuery(JDBC3Statement.java:73) at se.lantz.db.DbConnector.fetchGamesByView(DbConnector.java:323) at se.lantz.model.MainViewModel.setSelectedGameView(MainViewModel.java:404) at se.lantz.gui.ListPanel.setSelectedGameView(ListPanel.java:215) at se.lantz.gui.ListPanel.lambda$getListViewComboBox$0(ListPanel.java:172) at java.desktop/javax.swing.JComboBox.fireItemStateChanged(JComboBox.java:1227) at java.desktop/javax.swing.JComboBox.selectedItemChanged(JComboBox.java:1288) at java.desktop/javax.swing.JComboBox.contentsChanged(JComboBox.java:1335) at java.desktop/javax.swing.AbstractListModel.fireContentsChanged(AbstractListModel.java:123) at java.desktop/javax.swing.DefaultComboBoxModel.setSelectedItem(DefaultComboBoxModel.java:94) at se.lantz.model.MainViewModel.setupGameViews(MainViewModel.java:224) at se.lantz.model.MainViewModel.reloadGameViews(MainViewModel.java:239) at se.lantz.gui.MenuManager.importGamebaseGames(MenuManager.java:1130) at se.lantz.gui.MenuManager.lambda$getImportGamebaseItem$8(MenuManager.java:449) at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1967) at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2308) at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405) at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262) at java.desktop/javax.swing.AbstractButton.doClick(AbstractButton.java:369) at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1020) at java.desktop/javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1064) at java.desktop/java.awt.Component.processMouseEvent(Component.java:6636) at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3342) at java.desktop/java.awt.Component.processEvent(Component.java:6401) at java.desktop/java.awt.Container.processEvent(Container.java:2263) at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5012) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4844) at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4919) at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4548) at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4489) at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2307) at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2764) at java.desktop/java.awt.Component.dispatchEvent(Component.java:4844) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715) at java.base/java.security.AccessController.doPrivileged(AccessController.java:391) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745) at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743) at java.base/java.security.AccessController.doPrivileged(AccessController.java:391) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

lantzelot-swe commented 1 year ago

Ok, seems to happen if the genre name that is imported contains a ' character. I'll fix that.