Whenever someone tries to create a new article in my forum, this error shows up:
QuoteField 'shortname' doesn't have a default value
Fil: [...]\Sources\TPortalAdmin.php
Rad: 463
The forum's language is Swedish, so "Fil" is Swedish for "File" and "Rad" is Swedish for "Line".
The TP version is the latest, v0.9.8, and the SMF version is 1.1.3, also the latest. I have no other mods installed.
Link to my forum: (in Swedish) www.ugms.se
I believe the article-functions are hidden to guests though.
Feel free to use the search as most issues have been covered multiple times.
http://www.tinyportal.net/index.php?topic=15331.0
None of that works... I've tried using the manual DB install, no luck there, and I don't know any PHP so I can't edit the file myself, as many others did.
Could someone maybe show me how I should fix the TPortalAdmin temporarily so it'll work until the next TP version is released? Or is there another better way?
Show you how to work TPortalAdmin? You'll have to be more specific about what is not working so we can help you.
The error still pops up after I used the manual database install, so that didn't work. Upgrading PHP or MySQL isn't an option, since it isn't my own server.
What I tried to say in my previous post was that I would like to get some help with fixing the TPortalAdmin.php manually, that is, changing in the PHP code. I don't know any PHP so I can't do I myself without help.
Its not a PHP problem, its a MySQL problem where MySQL is expecting a value and there isn't one. I'm not sure what to change, but you can try going into your Database using something like phpMyAdmin. Click on the tp_articles table and edit the shortname row. Set the default column to 0 and see if it helps.
No, that didn't work, it says that shortname can't have a default value...
Can you attach your TPortalAdmin.php file please?
Done!
Can you try this one to see if it helps?
A new error now, with your changed file:
Incorrect integer value: '' for column 'category' at row 1
Fil: [...]\Sources\TPortalAdmin.php
Rad: 463
I'm going to see if I can replicate this on a test install I have. If you don't hear anything from me by tomorrow can you please PM me. Thanks.
Haven't been able to get the same results, so I can assume its only a problem because you may have a different version of MySQL than I do. Lets do a couple of things. First, change your TPortalAdmin.php file back to the original one you posted in this thread. Second, please post a phpinfo page if you can. More info on that at the following link.
http://www.simplemachines.org/community/index.php?topic=18250.0
And last, open phpMyAdmin and on the shortname row change the cell that says not null, to null. Then try again and see if you still get the same error.
Here's your phpinfo:
http://www.ugms.se/phpinfo.php
And I've already tried the last one, didn't work, same error...
Well, at this point I'll have to hope Bloc will have a moment to fix it.
but that working for me with u file Ichbin! TPortalAdmin.php but onlyy admin can post a articles not members why?
and i want to know why now i can't see a E in index page? E mean edit when you log in if you are admin u will see it show...
when members user can't post a articles when they post a articles or Upload file that will say
Database Error
Please try again. If you come back to this error screen, report the error to an administrator. :'(
I use lastest TP
Are you still having problems with your articles??
if so I have fixed mine
By changing my Database Table ***_tp_articles > shortname > Value to allow Null
And by editing the TPortalAdmin.php file in:
C:\{Directory where SMF was Installed}\Sources\TPortalAdmin.php
Go to Line:??? (whatever the error states - 463 I think) and change '$artc' to '0'
This will allow you to add articles with no errors!!!
;D
Hope this Helps you!!!