Python/Kivy POS System Part 4:Admin Dashboard(Part 21) 

It is in silverpos-master.zip\silverpos-master\admin_21 on his github

Hey there, you missed a line, above your product_code = [], add this: self.products = self.get_producrs()

@@samuelcourses7225 Thanks. I've make the changes. Now I get the following error: [INFO ] [Window ] virtual keyboard not allowed, single mode, not docked Traceback (most recent call last): File "admin.py", line 370, in AdminApp().run() File "/usr/local/lib/python3.7/site-packages/kivy/app.py", line 829, in run root = self.build() File "admin.py", line 367, in build return AdminWindow() File "admin.py", line 27, in __init__ self.products = self.get_products() File "admin.py", line 287, in get_products self.products = self.get_products() File "admin.py", line 287, in get_products self.products = self.get_products() File "admin.py", line 287, in get_products self.products = self.get_products() [Previous line repeated 148 more times] File "admin.py", line 275, in get_products database='pos' File "/usr/local/lib/python3.7/site-packages/mysql/connector/__init__.py", line 179, in connect return MySQLConnection(*args, **kwargs) File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 95, in __init__ self.connect(**kwargs) File "/usr/local/lib/python3.7/site-packages/mysql/connector/abstracts.py", line 716, in connect self._open_connection() File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 207, in _open_connection self._do_handshake() File "/usr/local/lib/python3.7/site-packages/mysql/connector/connection.py", line 101, in _do_handshake raise errors.get_exception(packet) mysql.connector.errors.DatabaseError: 1040: Too many connections This line [Previous line repeated 148 more times] tells me I gather that its been requesting 148 connections to the database and I read somewhere that you can only have 100 requests or increase the number of connections somewhere in a conf file. But I only need one conection or one conection at a time depending on what I'm doing to the database. Can you help me again please.

@@tarandalinux8323 I see, the problem is that you are supposed to be connecting only once. My guess is you have a problem in your code somewhere, can you pastebin the new code so I can take a look?

checkout github.com/qodzero/silverpos

Did you find a fix for this? I am also stuck at this part

Me, too. I tried in both a 3.6.8 venv and a 3.8 venv. Same error.

The problem is .kivy\garden\garden.matplotlib. The three test files under directory " .kivy\garden\garden.matplotlib\examples" all have the same error! I'll try to file a bug report, if there is not already one.

@@malcolmnooning2505 @Rhaez Mustapha Try this: pip install matplotlib==3.1.3 Found it here and it fixed the problem for me: github.com/facebook/prophet/issues/1691

@@WappyFallace This video course seems to not need _png, so my solution for now is to simply comment out the line trying to import it. In my case it is line 256 of garden.matplotlib\backend_kivy.py like so: #from matplotlib import _png