pellcorp/opendb

Open Media Lending Database

opendb's Issues

radio button sets in site plugin input fields

Hi,
I'd like to update the TMDB plugin to handle searches for TV listings but I really need to determine if the user is searching for a movie or TV show when submitting the search. I looked at the available input field types on the "Site Plugins Admin Tool" page but it seems that radio sets are not implemented. Could I request this functionality?

MobyGames Not Pulling in Information

MobyGames sql plugin pulls in title and that is about it!

Can't read menus

Hi

I've just installed Opendb for first time and it all seemed to work but when I log in to admin and try to use the Admin Tools or Main Menu menu,s the items in the menu list overlap each other and it is impossible to read them. I notice this also happens on your demo site.

Any ideas?

Thanks

Paul

add new item: "System:" field does not grow with additional systems added

Hi. Within "System Attribute Types Admin Tool", "GAMESYSTEM Attribute Type Lookups" I added some systems to show when adding new games (PS VITA, PS4, etc).
Now, when I want to add new games, the "System:" field with all the system icons is too small to show all systems. It does not "grow" with new systems being added with time.
Any idea maybe to change a line in item_input.php so the field grows with new systems being added?

Login with Cookie?

is it possible to stay permanently login with cookie for one Week or longer?

Issue #15 only handles 1 parent item, but the related item relationship allows many parent items

The item display functionality for related parent items allows have more than one parent, the current UI only appears to allow one parent to be defined.

I have merged a couple of minor changes to separate the UI, but it needs further rework before it can be considered completed.

"Specified key was too long" during install

I'm trying to install OpenDB, but I get the following error:

OpenDb 1.6.0beta2 Installation

New Install

The following install errors occurred:

Specified key was too long; max key length is 1000 bytes (1071)

CREATE TABLE s_site_plugin_s_attribute_type_lookup_map ( sequence_number INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, site_type VARCHAR(10) NOT NULL, s_attribute_type VARCHAR(30) NOT NULL, value VARCHAR(255) NOT NULL, lookup_attribute_val VARCHAR(50) NOT NULL, PRIMARY KEY ( sequence_number ), UNIQUE KEY ( site_type, s_attribute_type, value, lookup_attribute_val ) ) ENGINE=MyISAM COMMENT='Site Plugin Attribute Type Lookup Map'

Issue with #15 make parent item information visible

This is loading every single item as part of the format_item_parents_select, this is taking a long time to execute and needs to be refactored.

Site plugin The Movie Database update

The TMDB plugin has a small coding error
Line 93
$jsonData = json_decode($this->fetchURI($this->baseURL . 'movie/' . $search_attributes_r['tmdb_id'] . '?api_key=' . $this->apikey . '&append_to_response=casts', true), true);

should read

    $jsonData = json_decode($this->fetchURI($this->baseURL . 'movie/' . $search_attributes_r['tmdb_id'] . '?api_key=' . $this->apikey . '&append_to_response=casts'), true);

Thx,
Rob Boor

Add new related item functionality is broken

With the addition of functionality to create arbitrary relationships, the pre existing add new item instance relationships is now ignored.

In order to restore this functionality, the new code needs to be reworked again to ensure it works for the new and old functionality.

exec() has been disabled for security reasons

Just tried OpenDb on new hosting company. After installation I got warning

Warning: exec() has been disabled for security reasons in lib/OpenDbSnoopy.class.php on line 66

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at lib/OpenDbSnoopy.class.php:66) in include/begin.inc.php on line 120

Warning: Cannot modify header information - headers already sent by (output started at lib/OpenDbSnoopy.class.php:66) in lib/http.php on line 76

so I had to comment line 66 in lib/OpenDbSnoopy.class.php . Maybe some if(exec()) here would be good idea :-)

Languages lost after migrating from 1.0.5 to 1.5.0.8/1.6.0

Hi,

Some language/format combinations and therefore some languages are lost during the migration.

In 1.0.5:

In 1.6.0:

Installation failure

Installation of OpenDb 1.5.0.7 unfortunately failed with the message 👍

Pre Installation

The following pre-install errors occurred:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, PRIMARY KEY ( sequence_number ), UNIQUE KEY ( release_version ) )' at line 1 (1064)

CREATE TABLE s_opendb_release( sequence_number INTEGER(10) UNSIGNED NOT NULL auto_increment, release_version VARCHAR(50) NOT NULL, description VARCHAR(100) NOT NULL, upgrade_step TINYINT(2) UNSIGNED DEFAULT 0, upgrade_step_part TINYINT(2) UNSIGNED DEFAULT NULL, update_on TIMESTAMP(14) NOT NULL, PRIMARY KEY ( sequence_number ), UNIQUE KEY ( release_version ) ) TYPE=MyISAM COMMENT='System OpenDb Release table'

IMDB plugin no longer working

It seems the IMDB plugin is no longer working - with a "single find" no fields are filled and with multiple matches there are no titles and the links are all without numbers after tt (http://www.imdb.com/title/tt) - thumbnails looks correct

Amazon UPC lookup not working

When I scan the barcode to add a new DVD/BR it always comes back with nothing found. If I use the name it works, and when I open the Debug URL it loads a page with the movie for example. Debug output below. I am not sure when this started because I have been slacking on entering movies. I would be willing to try and fix it, but I am not sure what to look for, and have not coded php before.

Debug HTTP Requests

OpenDbSnoopy::fetchURI - URI: http://www.amazon.com/exec/obidos/external-search?index=dvd&keyword=025192052026&page=1
OpenDbSnoopy::fetchURI - URL cached

Length limit on attribute type names

I want to increase the attribute type length to more than 10 characters on my own copy and I'm just wondering if there was a technical reason it was limited to 10 in the first place?

Is there anything that I should be careful of when increasing the length?

Import Items does not work

Hello Jason!

I am a new opendb user and I have some problem with importing items. I tried to find a solution but I'm failed. I need your help, please!

So, when I wanted to importing items from the main menu I chose a csv file, or opendb xml file. I followed the process: choose file button - submit - match fields - import items button. Trial run was/was'nt checked. Everything looked good, but nothing was imported.
I tried this on the demo site with the same result.

My configuration:
os: windows 7
xampp: 5.6.8
MySQL: 5.6.24
php: 5.6.8
opendb: 1.6.0

Here is the content of the CSV file:
Title,Year
Werewolf The Beast Among Us,2012
Bad Ass,2012
The Tourist,2010

In the log it looks like the import file (csv for instance) processed corretly anyway.

Please help me if you can!

Thank You!

---

INFO admin ::1 20/07/15 14:30:06 lib/importcache.php import_cache_insert (?)
INFO admin ::1 20/07/15 14:30:06 lib/importcache.php import_cache_update_cachefile (?)
INFO admin ::1 20/07/15 14:30:14 lib/importcache.php import_cache_delete Deleted import_cache record (?)
INFO admin ::1 20/07/15 14:30:14 lib/fileutils.php delete_file (?)

---

Dot at the end of publisher name

Just inserted game with publisher "Big Robot Ltd.", click on that publisher should display me all games that are published by "Big Robot Ltd.". Instead, page says "No Matches Found". URL is:

listings.php?attribute_list=y&attr_match=word&attribute_type=GAMEPBLSHR&s_status_type=ALL&attribute_val="Big+Robot+Ltd."&order_by=title&sortorder=ASC

Then I removed dot from this URL:

listings.php?attribute_list=y&attr_match=word&attribute_type=GAMEPBLSHR&s_status_type=ALL&attribute_val="Big+Robot+Ltd"&order_by=title&sortorder=ASC

and I got displayed games that have "Big Robot Ltd." (with dot) as publisher.

Issue with installation on Windows (INSTALL file)

Just a heads up but when trying to clone this repo or install from the Git archive, there are problems on Windows.

Because there is a file (INSTALL) and folder (install) in the root of the repo, Windows will either show an error about the file / folder existing or, in the case of the GitHub app, delete one of the two.

Querying Amazon.De may sometimes return some incomplete or garbage data

Hi,

Not a big deal, but maybe can be fixed in one of the next releases.

Reproduction of error: Add a new item using AMAZON.DE plugin. Search for DVD, title Men in Black 3 Top three results show a DVD, first and third are the cover I was locking for.

The first has as title (contains garbage):
Men in Black 3 #energyEfficiencyTitleInformation { font-size: 19px !important;}

The third has en empty title

Cheers
Martin

Sorting does not work in 1.6.0

I try to sort by item id. As you can see, in 1.0.5 sort was ok, in 1.6.0 it does not sort.

In 1.0.5:

In 1.6.0:

Sorting by title however works fine.

View Permission not working on listings.php

if set 'ALT_ID' View Permission to Guest.

On item_display.php is hidden when logged out.
but on listings.php when logged out it always displayed Alt Item ID

is it possible to fix the problem?

thx

Question

This is more of a query than an issue. How do I get my hands on a full install of the site, or at least all the files I need to update my site plugins like Amazon? Looks like if you download the repository and try to install it does not work.

I currently have build 1.5.0.8dev2 installed.

Thanks

How to perform a proper MySQL export

First, I am still using the original 1.5.0.7 release, which I have recently modified to make it work with PHP 5.6. In this context I also tried to move from MySQL 4.1.22 to 5.6.19. However, all my attempts eventually failed. Both the original as well as the modified version are working fine with the MySQL4 database. However, if I am going to export everything and import it into a MySQL5 database, the listings always say "No match found".
Can you please tell me a proper way how to export the whole data and import it into a new database?

Amazon not pulling information

Running OpenDb 1.6.0.0dev4. Amazon plugin does not pull in information.

• Entering ISBN does not appear to search.
• Entering title searches and brings results, but clicking on one of the results does not pull the information into the form.
  • Entering the ASIN number returns "Undefined Error Occurred"

item_input can't remove secondary author

It happens sometimes after importing items from plugin searches, when data comes in bad formats so you have to doublecheck item fields.
When I try to remove secondary author, leaving the field blank, "authors must be specified" popups without any solution. As a workaround I used to duplicate primary author.

Failed to upgrade from 0.81

Hi,

I’m trying to update Opendb from 0.81p18 to the last 1.60beta3

And the upgrade stops here :

More than one upgrader is available for this version, this is an error,         
Upgrader: Upgrade from 1.5.7 to 1.6.0beta3
Upgrader: Upgrade from 1.5.7 to 1.6.0beta3

Thanks for your help !

Question on docs

Hello
I'm trying to use opendb and I didn't find docs for export/import items.
I looked in the old site and here. Maybe I didn't look in the right place.
Is there any documentation on it?
Thank you

Menues were not open on click

I run an installation of OpenDB (1.6beta4) on a 14.04.1 Ubuntu Server (PHP 5.5.9 / MySQL 5.5.41 / Apache 2.4.7).
My problem is, that it is unusable since the main menu, admin menu and the tabs (e.g. Information) were not shown up on click. They exist in the delivered html code.
This behavior is unrelated to the used browser, I tried Firefox, Midori and Chromium. So I think it is a problem of OpenDB (fresh installation and old but updated).

First line in gbooks.sql

When I tried to install gbooks plugin it gaves me an error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/usr/bin/curl

After removing the first line in gbooks.sql, everything works fine.

images with custom cover width from tmdb plugin

Hi,

I noticed that when a custom cover width is set in the configuration of the tmdb plugin the image url returned is incorrect.

e.g.
it gives:
http://d3gtl9l2a4fn1j.cloudfront.net/t/p/185/agy8DheVu5zpQFbXfAdvYivF2FU.jpg

instead of:
http://d3gtl9l2a4fn1j.cloudfront.net/t/p/w185/agy8DheVu5zpQFbXfAdvYivF2FU.jpg

P.S. It would be great if the title property from the "belongs_to_collection" object returned from the API could be included in the record data that is collected.

Move translation outside developing

Isn't the first time I translate this app in my language, Italian.
But every time (version change too much) I cant' finish completely cause there are many words to translate and many of these are not easy to be translated with accuracy.
Could be useful to open a translation project over one of these Social Translation Platforms, like Transifex, where many peoples could link together and focus only on this side of your project.
Maybe could be a fast solution for mass translation!
I'm going on with alone italian translation...

Upgrade from 1.0.6 to 1.6 failing

I'm a long time user of OpenDB. I started with a 0.8x install and have upgraded it to 1.0.6 some time ago. This was happily running on an Ubuntu 8.0.4 vm for years. I've recently killed the VM and installed a new 14.04 install and I'm now trying to upgrade to the latest opendb version.

I have the old database restored and moved the old webroot to the new server, that is all working fine.
However, Trying to upgrade to 1.6 I had several errors pointing me to first upgrade to 1.5 before trying to upgrade to 1.6.

I've downloaded the 1.5.0.4, however that fails the upgrade with a lot of SQL errors and corrupts my database (all items are gone).

Can you tell me what the recommended upgrade path would be in this case?

Category - where/how ?

Maybe I'm missing something really obvious..... but where/how do I add a category ?
I want to add new item types etc but its wanting a category set and for the life of me I cant see where to configure these..........

TIA

attributes only viewable to owner?

Hey

I was wondering if there is some clever way to define an attribute that is viewable only to the owner of a particular item? (and probably admins I guess)
perhaps some argument to put in the attribute editor?
I am currently doing it simply by having the display hidden, so one needs to edit the item to see it, but a better solution would be nice :) (I am using it to store serial numbers of some of my electronics, which I added as a category)

And by the way, thanks for a generally great piece of work you made - I am slowly adding all those things I always wanted to have a central overview over, but never pulled myself together to do because I wanted to do it properly 👍

item_input can't update or create item

hello.
i just upgraded from 1.5.4 to 1.6.0
when i try to update an item or record, the page hangs a lot of time and then write
"Item not found
Back to Listing"
i do not receive any kind of error message even in firebug.
even tryng to make a new install i can't insert any new media for the same problem.

i think it's a php configuration problem. i can post my phpinfo, if necessary

here are some information from phpmyadmin page.
Server: Localhost via UNIX socket
mysql -server : 5.5.35-0+wheezy1
protocol: 10
charset MySQL: UTF-8 Unicode (utf8)
Web server
Apache/2.2.22 (Debian)
MySQL client: 5.5.35
php-mysql; php-mysqli; php-pdomysql

Can't upgrade my installation

I have version 1.5.0.8RC1 up and running.

Now I wanted to upgrade my installation to the latest release (1.6.0beta4).
After the check of my system settings the script is giving me the following errror:
Fatal error: Cannot redeclare opendb_version_compare() (previously declared in /usr/www/users/nerdzo/opendb/lib/install.php:41) in /usr/www/users/nerdzo/opendb/functions/install.php on line 51

Then I tried if the upgrade to 1.5.0.8RC2 is working but there is a similar error:
Fatal error: Cannot redeclare opendb_version_compare() (previously declared in /usr/www/users/nerdzo/opendb/functions/install.php:45) in /usr/www/users/nerdzo/opendb/lib/install.php on line 46

Do you have any advice for me?

Demo site doesn't include blu-ray

Since the demo site seems to be a kitchen sink, it would be nice if gru-ray discs were enabled in the mix.

Moving 1.5.0.8RC2 causing issues

When moving from one server to another, i have encounted issues where I am unable to navigate to pages like the 'list all items'. I have created another test site and upgraded it to 1.6 beta2 and on that site I am unable to see anything (only the heading and mainmenu button which does nothing), but can login under my user name. I am a little stumped on this, and not sure where else to look, does anyone have any suggestions?

Plugin for Book Items

I discovered this website to looking for detailed books information worldwide, http://classify.oclc.org/classify2/. I used this site to manually add Dewey Decimal to books collection, but also other public libraries could appreciate a plugin based on this service!
I saw they have public APIs but I don't have the php basis to do this alone.
Could someone try to invent this?
I could help with testing, html&css.

Thanks

add new item: "System:" field does not grow with additional systems added

Not sure where issue 60 disappeared to, but I can confirm there is a bug. I have updated the demo site with the new items and the bug appears there. I am looking at what might be causing it and will push a gix.

only one Parent item show on Related Item

i have add the item
star trek 1 show all Related Parent Items
http://opendb.iamvegan.net/demo1.5/item_display.php?item_id=9894&instance_no=1

star trek 2 show only one Related Item (Star Trek 1)
http://opendb.iamvegan.net/demo1.5/item_display.php?item_id=9895&instance_no=1

it would be better when all item listed under related item

Refactor css to use something like foundation

Might make supporting newer browsers easier in longer term ,but a huge job

http://foundation.zurb.com/

bug on remember me

when load item listings with 21 images, have per load 20 new records with same user_id on the database remember_me table.

on welcome page with 40 images, have per load 39 new records with same user_id on the database remember_me table.

without images no problem only 1 user_id on the database remember_me table

Advanced search bug?

Hello,
I installed OpenDB 1.6.0.0 dev4 and I've been exploring it for a few days now. First of all, thanks for this application... I've come across a small issue and was wondering whether it might be a general problem or something specific to my installation. Here's the description.

In the Advanced Search, if I select
Attribute Type: ALT_TITLE - alternate title
(Attribute Type Lookup: only shows 'Use the value field --->' in the dropdown menu, so it's used)
Attribute Value: Guard
(default 'partial match' remains set)
and I hit Search, I draw a blank.

And yet there IS a film in my test collection that, in addition to the standard title (in the 'title' field in the 'item table'), has a corresponding alternate title of 'The Guard' (it is in the 'item_attribute' table and correctly shows up in the item's display page). Apparently there's either a bug in the MySQL query, or I'm simply not doing things properly... If the latter case, could someone please tell me how to search the database for an item, based on a part of the title, either in the TITLE itself OR in the ALT_TITLE fields?... Many thanks in anticipation.

Problems with amazon

I installed a new copy of the opendb 1.6.0beta4.
I also installed the amazonde site plugin (even tried it with amazon).
Whe i create a new item, i can search for it and it's found. But if i choose one of the found items, the input form for the film is empty. So only the title is filled in, with the term, which i searched.
With imdb, it works. Do i need to do more setup or sth like that or is it out of order?

Pre-install error - Too big precision on TImestamp

MySQL 5.6 error in CREATE TABLE s_opendb_release command. Too big precision of 14, allowable is 6.

themes documentation

Hi all
In online documentation (https://github.com/pellcorp/opendb/wiki/Themes) you say that a theme could define one of these functions:
theme_index()
theme_header($title)
theme_footer()
theme_image_src($src)
theme_image($src, $title, $type)

But in functions/theme.php I see that the functions used seems to be:
theme_header
theme_footer
theme_css_map
theme_image_src
theme_image

Thus:

• theme_index seems not used any more
• theme_css_map seems used but not documented

Now questions are:
1 - Is this true?
2 - I suppose that the page is built by:

• calling theme_header, having back the pre-item listing html
• calling something (what function?) in order to generate item listing html
• calling theme_footer having back the post-item listing html
  3 - what theme_css_map is used for?

iblist not working

Hey...

unfortunately it seems that the iblist advanced search which the site-plugin is based on does not work at all anymore...

The regular search (iblist.com/search/search.php?item=SEARCH_STRING&submit=Search) still seems to work. Unfortunately that does not work with isbn, but title and author is fine... I might try to hack the plugin to use this for now, but it's not really an optimal solution...
In any case, I tried to inform iblist of the bug, but their reporting system does not work, and it looks like project is dying, so perhaps a different plugin should be considered instead... Do you know if anyone did anything with Google Books for instance?

Stable release is not found

The releases page lists 1.5.0.7 as the latest release, however, it's not found in sourceforge:

http://prdownloads.sourceforge.net/opendb/OpenDb-1.5.0.7.zip

Are you sure that link works? It does not work for me no matter what I try.

Also, in the sourceforge page there is another version (1.0.2 or something) linked. The release archive does not have recent releases either.

Have you considered switching to github for this while you are at it?

Here is how to do releases with github: you tag a version with a "version friendly tag" (e.g. v1.5.0.7) and it appears in the versions tab. zip files and tarballs are automatically generated. Also, you may want to consider simplifying the version numbers.

Releases will show up in this page https://github.com/pellcorp/opendb/releases