MobileRead Forums - View Single Post - Glo Help! How to remove series display under title in library display??

davidfor · 05-27-2014, 02:34 AM

The paperclip reset is the equivalent of turning you PC off without doing a shutdown. In both cases, you will lose any unsaved changes, but sometimes it is the only way to get it going again. For the Kobo device, the series info will have been saved, so it shouldn't disappear. If you are missing more the last update to the reading status, you probably have a corrupt database that needs to be fixed.

There isn't any easy way to remove the series information from the device. All the work has been in how to get the correct info to the device.

There are three ways to do what you want:

Remove the book from the device and resend it later.
Logout out of the device and back in. This will recreate the database and reload the books into the library without the series info.
Clear the fields using SQL. You will need a tool to run the SQL against the database on the device. The following will do what you want:
Code:
```
UPDATE content
SET Series = NULL, 
 SeriesNumber  = NULL
WHERE ContentId like 'file%'
AND (Series IS NOT NULL
OR SeriesNumber  IS NOT NULL)
```

In all cases, you will need to make sure the series info option in the driver configuration is off.

05-27-2014, 02:34 AM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	The paperclip reset is the equivalent of turning you PC off without doing a shutdown. In both cases, you will lose any unsaved changes, but sometimes it is the only way to get it going again. For the Kobo device, the series info will have been saved, so it shouldn't disappear. If you are missing more the last update to the reading status, you probably have a corrupt database that needs to be fixed. There isn't any easy way to remove the series information from the device. All the work has been in how to get the correct info to the device. There are three ways to do what you want: Remove the book from the device and resend it later. Logout out of the device and back in. This will recreate the database and reload the books into the library without the series info. Clear the fields using SQL. You will need a tool to run the SQL against the database on the device. The following will do what you want: Code: UPDATE content SET Series = NULL, SeriesNumber = NULL WHERE ContentId like 'file%' AND (Series IS NOT NULL OR SeriesNumber IS NOT NULL) In all cases, you will need to make sure the series info option in the driver configuration is off.