Registered User
No pending resource
Hello, some days ago i ad a problem with SQL of my site, when the SQL come back new i put in it my backup. Now i have a problem, the submission of the users come to my website mail and i know that there is a pending resource but i log to my control panel there isn't any pending resource.
Can someone help me pls? My version of IndexU is 5.4
Regards.
Active Member
You did a complete restore of your database and not a partial restore? It sounds like your backup is incomplete.
Registered User
I do a complete restore of my DB.
Active Member
If everything is the same then it would be working, so something has to be different.
If it was a true backup then there would be no issues. Was it a backup done via cpanel or via the indexu admin panel?
Registered User
From IndexU admin panel.
Active Member
by "my control panel" I assume you mean you are trying to validate links and that the link does not appear when you browse the category listings. Thus, if you look at the idx_link table in phpmyadmin, you should not see the link. And it should not appear in the idx_link_temp table either.Originally Posted by franconov
sometimes there is just no easy way to find out what is wrong. In this particular case I'd try to figure out where the process breaks down. Start with the add.php file. Find the ProcessFormAddUrl function. on the first blank line of this function add the following code:
replace xxx with the line number. Upload and add a link. Did the "line=xxx" display on the screen (should be the top, left of the screen)?PHP Code:echo "<br>line=xxx";
since you got the email, you should see that on the screen. to verify that, look for a line "elseif ($add_result == 1) {" and add the echo line from above on the next line. Click the refresh button on your browser and enter any needed information. then click the submit button. Once again you should see the line displayed in the top left part of your screen.
You can probably skip the above two step if you want to.
Now open the link.class.php file. Since you are requesting approval, look for the line "elseif ($add_permission == 1) {" in the add function (about line 1573). at about line 1600 you will see a line "$vid = $dbConn->InsertID();"
on the next line, add the following:
based on what you have told us, you should see "vid=." you can then substitute the word "query" for "vid." Copy the SQL statement and execute it in your phpmyadmin. Did you get an error?PHP Code:echo "<br>vid=".$vid;
if you got "vid=xxx" where xxx is some number, then the link was added to the temp file and for some reason the validate function is not working in the ACP.
.
esm
"The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."
.
Registered User
The link that i submit from submission of website are in `idx_link_temp` of my DB but i don't see the link for my validation on my control panel.
Active Member
well, franconov, you are not exactly a fountain of information so far.
I'd really don't want to play "20 questions" to solve this problem. Did you click the "Validate Links" hyperlink in the Links section of the ACP? When you click that hyperlink, what happens? Do you get any kind of error message? Do the other hyperlinks work. If the data is in the sql table, why doesn't it show when you validate it? Is the data bad or is the php file bad? (that is a rhetorical question) It probably is one or the other. Did you try to upload (using ascii mode) the link_vaidate.php file?i don't see the link for my validation on my control panel.
You said "problem with SQL of my site." but it appears that the sql is fine and php file is a problem.
.
esm
"The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."
.
Registered User
Yes, sorry but after your answers seems a problem of php, but this problem is sorted after i import a backup of database.
Well, when i click on "validate links" in my ACP i go in a page where there is:
Validate Links
You have no awaiting link to validate.
Any message of error, others hyperlinks are ok.
I uploaded again the link_vaidate.php in ASCII mode but nothing to do any links in validate.
Active Member
look at your application.php file and make sure you connecting to the right database.
You could test the link_validate.php file or the Display function in the link.class.php file. this a fairly simple function to display any table rows to the screen. you could print the $num_rows variable. since you tell me you can see links in the idx_link_temp file, it should be something other than zero.
Otherwise, you could send an email/pm to support@nicecoder.com with your login/ftp information and have bruce take a look at it.
.
esm
"The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."
.
Administrator
Try to enter this query in admin panel -> database -> query
alter table `idx_link_temp` change `spam` `spam` char(1) NOT NULL default '0';
Registered User
Ok, thanks to all that help me after the query all is fine and i have pending resource.
Thanks a lot.
Administrator
it happen when you restore backup from backup files.
Active Member
You know, I saw that "spam" line in the link_validate.php file and wondered about it (it's not hard to miss since it is almost the first line). But data was being entered the expected way.
So I don't understand how restoring a back up could change the table properties. Unless the are wrong to begin with.
Oh, well.
.
esm
"The older I get, the more I admire competence, just simple competence, in any field from adultery to zoology."
.
Active Member
i guess the table default is 1? if so then isnt this a bug?
Main IndexU sites : | Campsite Directory | Tourist Guide | Places2B | AfterDirectory <-- Half price submission using coupon DP50 (from just $11 premium, and $10 basic permanent )
Posting Permissions
