Jump to content
TNG Community

*SOLVED* TNG 13 problem with Database/or Table-Access


MichaelM

Recommended Posts

HI,

I've upgraded my Xampp version from TNG 12.3 to TNG 13
==> All funktions are working

then I transfered the application to my public web server (my synology NAS) by
- copying the files via Filezilla
- copying the entire database by SQL-Export and -Import.

The Page is running,

I can access individual pages of individuals, families, Dsecendents, ancestors....,

but in different situations, I get Error Messages,

1.

i.e.: trying to acces a photo   ---
I see  thumb and preview- Picture but then following error-message  appears:

-------------------------------------

In TNG ist ein Fehler aufgetreten.
Falls Sie ein Update installiert haben, haben Sie möglicherweise einen Teil der Anleitung übersprungen. Bitte rufen Sie die Datei 'Readme' erneut auf und achten Sie besonders auf die Hinweise zur Anpassung der Datenbankstruktur.
Wenn Sie TNG zum ersten Mal installiert haben, müssen Sie möglicherweise noch die Datenbank anlegen. Bitte rufen Sie die Datei readme.html erneut auf.
Wenn Sie der Eigentümer der Internet-Site sind, möchten Sie vielleicht den Support für TNG kontaktieren. Bitte kopieren Sie die untenstehende Meldung und fügen Sie sie in eine E-Mail ein.

Abfrage: SELECT count(*) as rcount FROM WHERE mediaID="12879"

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE mediaID="12879"' at line 1

-----------------------------------------------------------

... Table-Name is missing in this SQL-Statement.
may be, this has something to do with Table tng_image_tags ?

2.

When I recall readme.html as recommended in above Error message and try to  use "upgrade_db123-13x.php" again, then I get another Error:
---------------------------------

Error: TNG is not communicating with your database. Please check your database settings and try again. Settings can be found under Admin/Setup/General Settings/Database, or at the top of your config.php file.

------------------------------------

3.

I tried both:  MariaDB 5   ( old setting on my NAS) and at least MariaDB 10 (as used under XAMPP)

4.

I also tried to export Database structure and BAK-Files from XAMPP and import into  public SIte:

Here I get the Error message: 

----------------------------------

 Kann Datei nicht öffnen .bak

cannot open .bak

----------------------------------

has somebody an idea ?

regards,

Michael

Edited by MichaelM
Solved
Link to comment
Share on other sites

Solved Solved Solved

 

It took me 4 Hours

The Problem was, that config.php  was excluded from Filetransfer to avoid conflicts with Database configuration.

so the Variable "$image_tags_table"   was empty.

thanks

 

Michael 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...