Before asking for help please read "Requesting Help and Suggestions" by clicking on that tab above here.
  • Page:
  • 1

TOPIC:

SQLSTATE[HY000]: General error: 1 month 3 weeks ago #1

  • suat24
  • suat24's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 26
i become this massage when i trade to chance someting of the tree1 data, and when i check out of a user (admin) can i not see my web site:
www.celebi24.com

what must i do?


SQLSTATE[HY000]: General error: 1364 Field 'm_ext' doesn't have a default value (SQL: insert into `wt_media` (`m_id`, `m_file`, `m_gedcom`) values (M10, 1, 0 @M10@ OBJE 1 FILE logo.jpg 2 FORM jpeg 3 TYPE photo 1 _PRIM Y 1 RESN none))

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1 month 3 weeks ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16208
This looks like you are using the latest version of webtrees with an old version of the database structure.

This should not be possible. Have you done anything with the database that might have caused this - e.g. restore individual tables from backup, etc.

Can you access your database using PhpMyAdmin or similar?

What value do you have for wt_schema_version in the table wt_site_setting?
Is the table wt_media empty?
Do you have a table wt_media_file? Is it empty?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1 month 2 weeks ago #3

  • suat24
  • suat24's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 26
Sorry I'm late in answering the questions.
The answers to the questions are:

This looks like you are using the latest version of webtrees with an old version of the database structure.

--> Yes, that's right. After updating the webtree, I put an old ged file on it.

This shouldn't be possible. Did you do anything to the database that might have caused this - e.g. restore individual tables from backup etc.

-->No I haven't changed the database structure, I don't know about it.

Can you access your database with PhpMyAdmin or similar?
--> Yes

What value do you have for wt_schema_version in the wt_site_setting table?
--> such an entry does not exist.

Is the wt_media table empty?
--> no

Do you have a wt_media_file table?
-->yes

is it empty
--> no
Attachments:

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1 month 2 weeks ago #4

  • Franz Frese
  • Franz Frese's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 363
You:
This looks like you are using the latest version of webtrees with an old version of the database structure.

--> Yes, that's right. After updating the webtree, I put an old ged file on it.

Me:
You did (and you do wonder? That will almost never work.)
Or did you simply import a gedcom file (what always is possible)

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1 month 2 weeks ago #5

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16208
The upgrade from 1.7 to 2.0 split the table wt_media into wt_media and wt_media_file.

The error is code from 1.7.
You have a database from 2.0

My guess is that you upgraded from 1.7 to 2.0 and then downgraded back to 1.7.

This isn't possible.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1 month 2 weeks ago #6

  • suat24
  • suat24's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 26
That was exactly my problem. Imported the last ged file I had.

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1 month 2 weeks ago #7

  • suat24
  • suat24's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 26
I can not answer that. I know that I have updated to 2.0. But didn't deliberately downgrade it to 1.7.

How can I solve the problem?

Is there a possibility to adapt the gedcom database?

Please Log in or Create an account to join the conversation.

Last edit: by suat24.

SQLSTATE[HY000]: General error: 1 month 2 weeks ago #8

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16208
Delete these folders:

app
resources
vendor
views

Then go through the upgrade to the latest version

webtrees.net/upgrade/manual/
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

SQLSTATE[HY000]: General error: 1 month 1 week ago #9

  • suat24
  • suat24's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 26
Did the suggested instruction. Unfortunately the same error message comes out.

Can I completely delete the database and create a new one? Or should you keep your hands off it?

Please Log in or Create an account to join the conversation.

SQLSTATE[HY000]: General error: 1 month 1 week ago #10

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 16208
> Can I completely delete the database and create a new one?

Yes. Presumably you have exported your genealogy data to a GEDCOM file.
In this case, you'll need to recreate all your user accounts, configuration settings, etc.

What you describe sounds odd. Maybe your database doesn't let you modify tables, or something like this...
Do you know what model/version of database you are using?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum