Cheagavara Posted May 3, 2022 Share Posted May 3, 2022 hi, ive been merging a mybb forum with a xenforo database and i get a message saying MyBB has experienced an internal SQL error and can not continue, i have attached a screenshot of the error message, any ideas about how to solve would be great, thanks for looking Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/ Share on other sites More sharing options...
Barand Posted May 3, 2022 Share Posted May 3, 2022 Looks like you were trying to write an empty string value into an column whose type is integer. Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595889 Share on other sites More sharing options...
Cheagavara Posted May 3, 2022 Author Share Posted May 3, 2022 how do i correct that? Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595891 Share on other sites More sharing options...
Barand Posted May 3, 2022 Share Posted May 3, 2022 Change the empty string value to an integer or NULL (if NULL is permitted). Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595892 Share on other sites More sharing options...
Cheagavara Posted May 3, 2022 Author Share Posted May 3, 2022 ok,....obvious question, how do i find it? your help is greatly appreciated and i should have come here first lol Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595893 Share on other sites More sharing options...
Barand Posted May 3, 2022 Share Posted May 3, 2022 Look for the problematic query. Does the MyBB Group have anything to offer? Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595894 Share on other sites More sharing options...
ginerjm Posted May 3, 2022 Share Posted May 3, 2022 Looking at that (blurry) message text it seems that you have a column named "pid" that you are trying to set to nothing as in "set pid='' ". As Barand has told you it looks like an integer (an id of some sort ?) and your table definition does not allow that. Either modify the structure of your table or supply a valid id value for that record Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595895 Share on other sites More sharing options...
Cheagavara Posted May 3, 2022 Author Share Posted May 3, 2022 myBB group have not offered any insight, i have found similar queries but not much in the way of solutions and none exactly the same, occurring during running the merge software. im am new (very new) to php and am trying to learn as i go along, im trying to rescue a community free forum that was run for years on xenforo until the person who handled it disappeared and screwed the forum. taking what you said above, and i am thankful, is it possible to guide idiot proof on how to identify it and what to change? Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595897 Share on other sites More sharing options...
ginerjm Posted May 3, 2022 Share Posted May 3, 2022 Show us the code around where the error message is coming from. Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595908 Share on other sites More sharing options...
Cheagavara Posted May 3, 2022 Author Share Posted May 3, 2022 1 hour ago, ginerjm said: Show us the code around where the error message is coming from. if you could tell me where to look....... i am quite new to this and learning fast Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595909 Share on other sites More sharing options...
Barand Posted May 3, 2022 Share Posted May 3, 2022 3 minutes ago, Cheagavara said: if you could tell me where to look.... Hmm.. how about the project's code? Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595910 Share on other sites More sharing options...
Cheagavara Posted May 4, 2022 Author Share Posted May 4, 2022 if i gave you the host loging details would you be able to have a look? im still trying to get my head around the code having up until now only had experience of html Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595932 Share on other sites More sharing options...
ginerjm Posted May 4, 2022 Share Posted May 4, 2022 You are running something from your web browser, yes? What is the name and location of that script from the address bar? Use your editor to open up that script. Start reading it and look for that query mentioned in the error message box and copy the lines leading up to it and paste them into a a post here. Be sure to place them in the proper code box triggered by the <> icon above your message. This will help us to see what you are doing and perhaps point out the issue. If you cannot do any of this then perhaps you need to step away and get someone else to solve this on your end. We are not here to do your tasks, only to help you do them. Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595933 Share on other sites More sharing options...
Cheagavara Posted May 4, 2022 Author Share Posted May 4, 2022 (edited) 54 minutes ago, ginerjm said: You are running something from your web browser, yes? What is the name and location of that script from the address bar? Use your editor to open up that script. Start reading it and look for that query mentioned in the error message box and copy the lines leading up to it and paste them into a a post here. Be sure to place them in the proper code box triggered by the <> icon above your message. This will help us to see what you are doing and perhaps point out the issue. If you cannot do any of this then perhaps you need to step away and get someone else to solve this on your end. We are not here to do your tasks, only to help you do them. ok, thank you and you are absolutely right i either need to know how to do this (learn) or stop. the error message only appears when i am running the emerge software, which i am not at the moment Edited May 4, 2022 by Cheagavara Quote Link to comment https://forums.phpfreaks.com/topic/314755-merging-forums-gets-1366-incorrect-interger-value/#findComment-1595937 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.