[Version 2 Release] RaspberryPints - Digital Taplist Solution

[RandR+]

I've tried everything possible using Inspect Element, but haven't been able to make it work.

check the Drinks/remaining Header, it has a height of 75px, when I disable that the header shrinks to only be as tall as the tallest text (AGV/Calories/Gravity in this picture)

 

[pmd5700]

check the Drinks/remaining Header, it has a height of 75px, when I disable that the header shrinks to only be as tall as the tallest text (AGV/Calories/Gravity in this picture)

Thank you! I guess I didn't look hard enough

 

[pmd5700]

One more php/css question: I'm trying to increase the size of the beer images. I can change it using Inspect Element and it works fine, but I can't find it in any of the php or css files. Thanks!

 

[Gengasi]

@RandR+ No i am sorry sir, the issue havent been fixed. If i pour 300milliliters, calibrates it to 300 milliliters in the tap section it still subtracters around 1 litre from the keg everytime a pour registered. If there is anything i can do to showcase this issue i would gladly help.

 

[RandR+]

but I can't find it in any of the php or css files.

includes/beerListTable.php line 208

and includes/beerListTableVertical.php line 179 change the inline width

 

[RandR+]

If there is anything i can do to showcase this issue i would gladly help.

if you could get a screen shot of your admin taps page with pin settings shown (check show pin settings) that would help would help I need to see the count per L/Gal (you can also change that textbox and hit save to manually update the count instead of using the calibration screen)

The other thing that would help is having whats the unit for that taps in your tapConfig table
run this from the terminal (replace RaspberryPints with your database name)
sudo mysql -e "SELECT countUnit from RaspberryPints.tapconfig"

 

[pmd5700]

includes/beerListTable.php line 208
View attachment 704497
and includes/beerListTableVertical.php line 179 change the inline width
View attachment 704498

Hmmm...that's what I originally thought and tried, but the picture still comes in as 100px wide.

 

[RandR+]

but the picture still comes in as 100px wide.

I tried on my test system and it work
did you verify your file saved?
Im guessing you check element inspector to see its still 100,
did you try cntrl + f5 to force refresh?

 

[pmd5700]

I tried on my test system and it work
did you verify your file saved?
Im guessing you check element inspector to see its still 100,
did you try cntrl + f5 to force refresh?

Hmm - weird. It's definitely saved. If I reopen my beerListTable.php file, it shows 150px. In my inspect element (with Ctrl + F5) it still shows 100px.

 

[RandR+]

If I reopen my beerListTable.php file, it shows 150px. In my inspect element (with Ctrl + F5) it still shows 100px.

I see I gave you the wrong information...my bad
you need to modify includes /functions.php line 120

the lines earlier for the brewery image

 

[pmd5700]

I see I gave you the wrong information...my bad
you need to modify includes /functions.php line 120
View attachment 704583
the lines earlier for the brewery image

That was it, thank you!

 

[pmd5700]

Yet another question...sorry! If I want to show my last pour in the right hand corner, but not the list at the bottom, is that possible?

My configuration looks like this: but I see the last pour at the top right and the pour list at the bottom. Or did I break something messing with the php files

 

[RandR+]

but I see the last pour at the top right and the pour list at the bottom

I see my code is setup that if you have Show Last pour On it will show the pour in the upper right and in the list on the bottom.

I changed it so it wont display the list if Show List is off, but show last is on

its a small change in index.php line 276 keep $numberOfPours at 0
6

 

[pmd5700]

If I wanted to copy my entire install to a new SD Card and Pi, what would I have to copy to get minimal reconfiguring? Just the entire HTML folder? Is everything stored inside there?

 

[day_trippr]

Why not use the Raspian SD Card Copier utility, clone the running card using a cheap SD card "reader", then sneakernet the clone to the new RPi. You just need to change system names and related stuff (unplug the original RPi while you're doing that), but otherwise it's a quick and easy way to expand a RaspberryPi fleet...

Cheers!

 

[pmd5700]

Why not use the Raspian SD Card Copier utility, clone the running card using a cheap SD card "reader", then sneakernet the clone to the new RPi. You just need to change system names and related stuff (unplug the original RPi while you're doing that), but otherwise it's a quick and easy way to expand a RaspberryPi fleet...

Cheers!

Thanks! I'll take a look. I should explain the full reason for my question though... Something happened to my install and I cannot get it to start at all. I was going to try a fresh install on a new SD Card and copy my HTML folder over. I did that, but clearly I was missing something. None of my beers showed up and most of my formatting was not correct.

 

[day_trippr]

I'll certainly defer to @RandR+'s take but from what I've been seeing the last few months you may be able to solve your problems re-running his installation script...

Cheers!

 

[pmd5700]

I'll certainly defer to @RandR+'s take but from what I've been seeing the last few months you may be able to solve your problems re-running his installation script...

Cheers!

I think I'm having a problem with MariaDB or phpmyadmin (or something). I get this error now when I try to Reconfig or Reinstall:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

EDIT: I got it back up and running on a new SD Card through a series of copying files from HTML and an old SQL Backup.

 

[DNuggs]

Hey guys,
I've been using RandR+'s version for the last few months which generally works great but I did have two quick items I could use some help on. With regards to updating the software, do you have to download an updated version prior to clicking on the "update" button on the install page in admin mode? Or by clicking that button, does it automatically just pull the updates from an established database? Secondly, I can not for the lift of me get the motion detector to work. I did select yes when asking about motion detectors doing the initial install and I've gone into the motion detector settings on the admin page and put in pin 26 as my PI pin (as that what it's connected to) but my screen remains on all the time. Thoughts?

 

[RandR+]

I got it back up and running on a new SD Card through a series of copying files from HTML and an old SQL Backup.

Glad you got it working, just wanted to note that copying the HTML folder will only copy your customization, you still need get a backup of the database which you did

 

[RandR+]

"update" button on the install page in admin mode? Or by clicking that button, does it automatically just pull the updates from an established database

update button update the database only, Get Latest RPints button should automatically pull the latest code from GitHub and run the database update, equivalent to running the install script and selecting update.

but my screen remains on all the time. Thoughts?

Either the motion detector is always sensing motion or your screensaver isn't kicking in.
Look at /var/log/rpints.log to see if there is anything about the motion detector in there.
You can check the screensaver setting by opening Screensaver under the preferences of the main Raspbian menu (start menu)

 

[DNuggs]

update button update the database only, Get Latest RPints button should automatically pull the latest code from GitHub and run the database update, equivalent to running the install script and selecting update.

I don't actually see a "get latest RPints" button

Either the motion detector is always sensing motion or your screensaver isn't kicking in.
Look at /var/log/rpints.log to see if there is anything about the motion detector in there.
You can check the screensaver setting by opening Screensaver under the preferences of the main Raspbian menu (start menu)

interestingly, there isn't a screensaver option under the preferences bar

 

[RandR+]

there isn't a screensaver option under the preferences bar

ok from the terminal run
sudo apt-get install xscreensaver

I review the install script I tried it on a test machine and it did the same thing but that command is clearly in there

 

[DNuggs]

Tried doing that but I get the message “unable to fetch some archives”

also, there is not “get latest update” in my admin settings that I can see

 

[RandR+]

Tried doing that but I get the message “unable to fetch some archives”

also, there is not “get latest update” in my admin settings that I can see

try
sudo apt-get update
sudo apt-get install xscreensaver --fix-missing

Get Latest RPints is under the Install Page. If its not there then you probably havent updated since i added it.
You can run
curl -L install.rpints.com | sudo bash
and select the update options

 

[DNuggs]

try
sudo apt-get update
sudo apt-get install xscreensaver --fix-missing

Get Latest RPints is under the Install Page. If its not there then you probably havent updated since i added it.
You can run
curl -L install.rpints.com | sudo bash
and select the update options
View attachment 705454
View attachment 705455

worked perfectly! as always, thank you for helping us non-programmers navigate this whole thing

 

[theglobalguy]

Heya RandR+, I found a similar issue with the screensaver a while back under a fresh install. I mentioned it a few weeks ago, but it could have easily been overlooked....review this post if you want. [Version 2 Release] RaspberryPints - Digital Taplist Solution

 

[fun4stuff]

@fun4stuff I like your taplist! Where did you get those numbers and how did you add them?

I got them from another HBT member. If you want to PM me your email, i can forward them your way!

 

[pmd5700]

I got them from another HBT member. If you want to PM me your email, i can forward them your way!

Thanks! I actually ended up making my own.

 

[RandR+]

I mentioned it a few weeks ago, but it could have easily been overlooked

Ya I saw that but didn't act on it till now, I fixed the install script to actually install xscreensaver